From d033c570ad9d40c28b512ad567427a47a7a111ff Mon Sep 17 00:00:00 2001 From: Bryan Newbold Date: Mon, 8 Mar 2021 16:15:12 -0800 Subject: sql dump recent timing note --- extra/sql_dumps/README.md | 3 ++- 1 file changed, 2 insertions(+), 1 deletion(-) (limited to 'extra/sql_dumps') 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 -- cgit v1.2.3