pg_dump 3 times as slow after 8.4 -> 9.5 upgrade

2017-11-21 Thread Henrik Cednert (Filmlance)
Hello We use a system in filmproduction called DaVinci Resolve. It uses a pgsql database when you work in a collaborative workflow and multiple people share projects. Previously it was using pgsql 8.4 but for a new major upgrade they recommend an upgrade to 9.5. Probably also to some macOS limi

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

2017-11-21 Thread Henrik Cednert (Filmlance)
From: Henrik Cednert (Filmlance) [mailto:henrik.cedn...@filmlance.se] Sent: Tuesday, November 21, 2017 9:29 AM To: pgsql-performance@lists.postgresql.org<mailto:pgsql-performance@lists.postgresql.org> Subject: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade Hello We use a system in

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

2017-11-21 Thread Henrik Cednert (Filmlance)
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 ] On 21 Nov 2017, at 17:34, Igor Neyman mailto:iney...@perceptron.com>> wrote: From: Henrik Cednert (Fil

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

2017-11-21 Thread Henrik Cednert (Filmlance)
mobile [ + 46 (0)704 71 89 54 ] skype [ cednert ] On 21 Nov 2017, at 17:44, Igor Neyman mailto:iney...@perceptron.com>> wrote: From: Henrik Cednert (Filmlance) [mailto:henrik.cedn...@filmlance.se] Sent: Tuesday, November 21, 2017 11:37 AM To: pgsql-performance@lists.pos

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

2017-11-21 Thread Henrik Cednert (Filmlance)
Hello Running it with format "directory" produced something I cannot import form the host application. So I aborted that. Running it now and recording with Instruments. Guess I'll have to leave it cooking for the full procedure but I've added an initial one to pastebin. https://pastebin.com/QHR

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

2017-11-21 Thread Henrik Cednert (Filmlance)
mlance International mobile [ + 46 (0)704 71 89 54 ] skype [ cednert ] On 21 Nov 2017, at 22:01, Tom Lane mailto:t...@sss.pgh.pa.us>> wrote: "Henrik Cednert (Filmlance)" mailto:henrik.cedn...@filmlance.se>> writes: I'm not sure if I can attach screenshots here. Trying, s

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

2017-11-21 Thread Henrik Cednert (Filmlance)
t cto | compositor Filmlance International mobile [ + 46 (0)704 71 89 54 ] skype [ cednert ] On 22 Nov 2017, at 04:48, Henrik Cednert (Filmlance) mailto:henrik.cedn...@filmlance.se>> wrote: This sender failed our fraud detection checks and may not be who they appear to be. Learn about spoofing<

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

2017-11-22 Thread Henrik Cednert (Filmlance)
g.net>> wrote: On Nov 21, 2017, at 10:18 PM, Henrik Cednert (Filmlance) mailto:henrik.cedn...@filmlance.se>> wrote: WHat's the normal way to deal with compression? Dump uncompressed and use something that threads better to compress the dump? I would say most likely your zlib is sc

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

2017-11-22 Thread Henrik Cednert (Filmlance)
le [ + 46 (0)704 71 89 54 ] skype [ cednert ] On 22 Nov 2017, at 13:17, Henrik Cednert (Filmlance) mailto:henrik.cedn...@filmlance.se>> wrote: This sender failed our fraud detection checks and may not be who they appear to be. Learn about spoofing<http://aka.ms/LearnAboutSpoofi

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

2017-11-22 Thread Henrik Cednert (Filmlance)
go so would be nice to get this to work properly anyways. =) CHeers and many thanks again. -- Henrik Cednert cto | compositor Filmlance International On 22 Nov 2017, at 20:52, Matthew Hall mailto:mh...@mhcomputing.net>> wrote: On Nov 22, 2017, at 5:06 AM, Henrik Cednert (Filmlance) mai

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

2017-11-23 Thread Henrik Cednert (Filmlance)
On 22 Nov 2017, at 22:07, Patrick KUI-LI 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 t