From: Gunther <raj@gusw.net>
To: pgsql-performance@lists.postgresql.org
Subject: Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade
Date: Thu, 7 Dec 2017 07:46:36 -0500
Message-ID: <fbcba138-d467-440a-53c5-dae03e926170@gusw.net> (raw)
In-Reply-To: <A456F355-B91C-42CD-AFA1-6572CA2C1546@filmlance.se>
References: <8F33D0C7-E12E-4996-990C-3CF0C5ED0437@filmlance.se>
<0bc6cc72-7d7d-b157-4824-7a6ea2985a60@hipay.com>
<A456F355-B91C-42CD-AFA1-6572CA2C1546@filmlance.se>
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 <pkuili@hipay.com
>> <mailto:pkuili@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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: raj@gusw.net, pgsql-performance@lists.postgresql.org
Subject: Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade
In-Reply-To: <fbcba138-d467-440a-53c5-dae03e926170@gusw.net>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox