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

От

Henrik Cednert (Filmlance)

Тема

Дата

21 ноября 2017 г. в 19:48:07

Msg-id

540BF7AC-F405-4DE5-9B58-5DC2E70F3B68@filmlance.se

обсуждение

Ответ на

RE: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade (Igor Neyman)

Список

pgsql-performance

Дерево обсуждения

pg_dump 3 times as slow after 8.4 -> 9.5 upgrade "Henrik Cednert (Filmlance)" <henrik.cednert@filmlance.se> 21 ноября 2017 г. в 17:28:43

Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Patrick KUI-LI <pkuili@hipay.com> 23 ноября 2017 г. в 00:07:30

Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade "Henrik Cednert (Filmlance)" <henrik.cednert@filmlance.se> 23 ноября 2017 г. в 12:26:16

Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Gunther <raj@gusw.net> 7 декабря 2017 г. в 15:46:36

Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Laurenz Albe <laurenz.albe@cybertec.at> 7 декабря 2017 г. в 20:31:35

Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Claudio Freire <klaussfreire@gmail.com> 7 декабря 2017 г. в 20:56:37

Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Tom Lane <tgl@sss.pgh.pa.us> 21 ноября 2017 г. в 20:01:27

Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Robert Haas <robertmhaas@gmail.com> 21 ноября 2017 г. в 21:39:26

Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Tom Lane <tgl@sss.pgh.pa.us> 21 ноября 2017 г. в 21:46:09

Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade "Henrik Cednert (Filmlance)" <henrik.cednert@filmlance.se> 21 ноября 2017 г. в 21:59:08

Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade "Henrik Cednert (Filmlance)" <henrik.cednert@filmlance.se> 21 ноября 2017 г. в 21:53:29

Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Tom Lane <tgl@sss.pgh.pa.us> 22 ноября 2017 г. в 00:01:20

Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade "Henrik Cednert (Filmlance)" <henrik.cednert@filmlance.se> 22 ноября 2017 г. в 06:48:09

Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade "Henrik Cednert (Filmlance)" <henrik.cednert@filmlance.se> 22 ноября 2017 г. в 09:18:08

Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Matthew Hall <mhall@mhcomputing.net> 22 ноября 2017 г. в 13:32:45

Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Andres Freund <andres@anarazel.de> 22 ноября 2017 г. в 19:56:19

Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade "Henrik Cednert (Filmlance)" <henrik.cednert@filmlance.se> 22 ноября 2017 г. в 15:17:30

Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade "Henrik Cednert (Filmlance)" <henrik.cednert@filmlance.se> 22 ноября 2017 г. в 16:06:58

Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Matthew Hall <mhall@mhcomputing.net> 22 ноября 2017 г. в 22:52:11

Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade "Henrik Cednert (Filmlance)" <henrik.cednert@filmlance.se> 22 ноября 2017 г. в 23:06:53

RE: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Igor Neyman <ineyman@perceptron.com> 21 ноября 2017 г. в 19:25:17

Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade "Henrik Cednert (Filmlance)" <henrik.cednert@filmlance.se> 21 ноября 2017 г. в 19:27:12

RE: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Igor Neyman <ineyman@perceptron.com> 21 ноября 2017 г. в 19:34:03

Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade "Henrik Cednert (Filmlance)" <henrik.cednert@filmlance.se> 21 ноября 2017 г. в 19:37:13

RE: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Igor Neyman <ineyman@perceptron.com> 21 ноября 2017 г. в 19:44:38

Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade "Henrik Cednert (Filmlance)" <henrik.cednert@filmlance.se> 21 ноября 2017 г. в 19:48:07

RE: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Igor Neyman <ineyman@perceptron.com> 21 ноября 2017 г. в 19:57:30

Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Shaul Dar <shauldar@gmail.com> 21 ноября 2017 г. в 19:44:23

I VACUUM every sunday so that is done already. =/

Not sure I have the proper params though since I'm not used to db's but have followed other's "how to's", but these are the lines in my script for that;

${BINARY_PATH}/vacuumdb --analyze --host=localhost --username=postgres --echo --verbose --no-password ${database} | tee -a ${log_pg_optimize}_${database}.log

${BINARY_PATH}/reindexdb --host=localhost --username=postgres --no-password --echo ${database} | tee -a ${log_pg_optimize}_${database}.log

--
Henrik Cednert
cto | compositor

Filmlance International
mobile [ + 46 (0)704 71 89 54 ]
skype [ cednert ]

On 21 Nov 2017, at 17:44, Igor Neyman <ineyman@perceptron.com> wrote:

From: Henrik Cednert (Filmlance) [mailto:henrik.cednert@filmlance.se]
Sent: Tuesday, November 21, 2017 11:37 AM
To: pgsql-performance@lists.postgresql.org
Subject: Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade

Attention: This email was sent from someone outside of Perceptron. Always exercise caution when opening attachments or clicking links from unknown senders or when receiving unexpected emails.

RAID6. Doing disk test I have 1000MB/sec write and 1200MB/sec read.

--
Henrik Cednert
cto | compositor

Filmlance International
mobile [ + 46 (0)704 71 89 54 ]
skype [ cednert ]

_________________________________________________________________________________________________

Okay, I was kind of wrong about 40GB. That’s the size of your compressed backup files, not the size of your databases.
May be your dbs are “bloated”?
You could try VACUUM FULL on your databases, when there is no other activity.

Igor Neyman

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

Предыдущее

От: Igor Neyman

Дата: 21 ноября 2017 г. в 19:44:38

Сообщение: RE: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade

Следующее

От: Igor Neyman

Дата: 21 ноября 2017 г. в 19:57:30

Сообщение: RE: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade