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

Поиск
Список
Период
Сортировка
От Gunther
Тема Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade
Дата
Msg-id fbcba138-d467-440a-53c5-dae03e926170@gusw.net
обсуждение исходный текст
Ответ на Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade  ("Henrik Cednert (Filmlance)" <henrik.cednert@filmlance.se>)
Ответы Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade  (Laurenz Albe <laurenz.albe@cybertec.at>)
Список pgsql-performance

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> 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

В списке pgsql-performance по дате отправления:

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: Bitmap scan is undercosted? - boolean correlation
Следующее
От: Ulf Lohbrügge
Дата:
Сообщение: Re: [PERFORM] Slow execution of SET ROLE, SET search_path and RESET ROLE