summaryrefslogtreecommitdiffstats
path: root/extra/sql_dumps
diff options
context:
space:
mode:
authorBryan Newbold <bnewbold@robocracy.org>2021-03-08 16:15:12 -0800
committerBryan Newbold <bnewbold@robocracy.org>2021-03-08 16:15:12 -0800
commitd033c570ad9d40c28b512ad567427a47a7a111ff (patch)
treea801f6d07015729f96a5d26697dc448ab7396da1 /extra/sql_dumps
parent79cbfe0cc59acb4bfa24149b892dfb15ae012980 (diff)
downloadfatcat-d033c570ad9d40c28b512ad567427a47a7a111ff.tar.gz
fatcat-d033c570ad9d40c28b512ad567427a47a7a111ff.zip
sql dump recent timing note
Diffstat (limited to 'extra/sql_dumps')
-rw-r--r--extra/sql_dumps/README.md3
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