| From: | Hu Bert <revirii(at)googlemail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | After upgrade pg12 -> pg14 import time increased |
| Date: | 2022-02-25 08:25:29 |
| Message-ID: | CAAV-989+T6QYJRJV_O4YC7wdOgsatT02rETVtTXJ96HaHvN8Jw@mail.gmail.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Hello,
starting with an explanation first... i have some sort of 'cold
backup' system: it rsyncs a postgres dump (size: ~1.5TB) from the main
system (created with 'pg_dump $dbname > db.sql) to the backup system
(10TB hdds in a raid10), and then automatically imports that dump
(psql $dbname < $db.sql) into postgres. So the backup system
stores/provides the database of each day (cleanup of older stuff done
manually). copy+import normally finished within 16-18 hours.
About 4 weeks ago both systems were running with postgres12 on debian
buster; then the switch to postgres14 was done, first on main system,
later on the backup system (both with pg_upgrade, no problems here).
But after that switch the import time on the backup system increased,
now taking more than 24 hours. A dist-upgrade to debian bullseye was
done, but no improvement.
I was checking release notes (releases 13+14), but, somehow, nothing
catched my eye.
hardware of backup system:
128G ram, raid10 (ext4, 4 disks) for postgresql, raid10 (ext4, 6
disks) for sql backup files
shared_buffers = 32768MB
work_mem = 16384MB
maintenance_work_mem = 16384MB
effective_cache_size = 16GB
no read/write operations on the backup system. any idea what could've
changed? more information needed?
thx,
Hubert
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Laurenz Albe | 2022-02-25 09:33:12 | Re: \set \e and newline |
| Previous Message | Wim Bertels | 2022-02-24 17:16:48 | \set \e and newline |