Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade

From: "Henrik Cednert (Filmlance)" <henrik(dot)cednert(at)filmlance(dot)se>
To: "pgsql-performance(at)lists(dot)postgresql(dot)org" <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade
Date: 2017-11-23 09:26:16
Message-ID: A456F355-B91C-42CD-AFA1-6572CA2C1546@filmlance.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On 22 Nov 2017, at 22:07, Patrick KUI-LI <pkuili(at)hipay(dot)com<mailto:pkuili(at)hipay(dot)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
real 82m33.744s
user 60m55.069s
sys 3m3.375s

COMPRESSION LEVEL: 6, SSL OFF
real 76m31.083s
user 61m23.282s
sys 1m23.341s

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Dmitry Shalashov 2017-11-23 14:58:23 Re: Query became very slow after 9.6 -> 10 upgrade
Previous Message Tom Lane 2017-11-22 23:07:07 Re: Query became very slow after 9.6 -> 10 upgrade