diff options
| author | Bryan Newbold <bnewbold@robocracy.org> | 2021-03-08 16:15:12 -0800 |
|---|---|---|
| committer | Bryan Newbold <bnewbold@robocracy.org> | 2021-03-08 16:15:12 -0800 |
| commit | d033c570ad9d40c28b512ad567427a47a7a111ff (patch) | |
| tree | a801f6d07015729f96a5d26697dc448ab7396da1 | |
| parent | 79cbfe0cc59acb4bfa24149b892dfb15ae012980 (diff) | |
| download | fatcat-d033c570ad9d40c28b512ad567427a47a7a111ff.tar.gz fatcat-d033c570ad9d40c28b512ad567427a47a7a111ff.zip | |
sql dump recent timing note
| -rw-r--r-- | extra/sql_dumps/README.md | 3 |
1 files changed, 2 insertions, 1 deletions
diff --git a/extra/sql_dumps/README.md b/extra/sql_dumps/README.md index 1fa37981..388831d6 100644 --- a/extra/sql_dumps/README.md +++ b/extra/sql_dumps/README.md @@ -64,7 +64,8 @@ In production: time sudo -u postgres pg_dump --verbose --format=tar fatcat_prod | pigz > /srv/fatcat/snapshots/fatcat_full_dbdump_${DATESLUG}.tar.gz In production (as of 2019-04-24, with a 283 GByte PostgreSQL database), this -takes 1h40m. +takes 1h40m. As of 2021-03-06, with a 705.19G PostgreSQL database (172 GByte +compressed dump), it takes 2h40m. NOTE: by using the "directory" export (along with `--file`) instead of "tar" export, it would be possible to use parallel dumping. However, this would put |