I confess I don't do dump or any backups much other than file system
snapshots.
But when I do, I don't like how long it takes.
I confess my database is big, I have about 200 GB. But still, dumping it
should not take 48 hours (and running) while the system is 75% idle and
reads are at 4.5 MB/s when the system sustains over 100 MB/s during
processing of table scan and hash join queries.
Something is wrong with the dump thing. And no, it's not SSL or
whatever, I am doing it on a local system with local connections.
Version 9.5 something.
regards,
-Gunther
On 11/23/2017 4:26, Henrik Cednert (Filmlance) wrote:
On 22 Nov 2017, at 22:07, Patrick KUI-LI <pku...@hipay.com
<mailto:pku...@hipay.com>> wrote:
Hello,
I had this behaviors when the upgraded pg 9.5 was on ssl mode by default.
So i deactivated ssl mode in postgresql.conf. That's all.
Regards,
Patrick
Hello
And you just uncommented the 'ssl = off' line in the config for this?
Is this default behaviour different from 8.4? Is there a 'show running
config' for pgsql?
I tried that in the test vm and didn't really give me a significant
difference.
COMPRESSION LEVEL: 6, SSL ON
real82m33.744s
user60m55.069s
sys3m3.375s
COMPRESSION LEVEL: 6, SSL OFF
real76m31.083s
user61m23.282s
sys1m23.341s
