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

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 On 11/21/2017 03:28 PM, Henrik Cednert (Filmlance) wrote: > Hello > > We use a system in filmproduction called DaVinci Resolve. It uses

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

Hi Matthew Actually running that test in a vm right now. =) This is the same db dumped from 9.5 and 8.4 with compression 6 in the same system (smaller db in a vm). 9.5: real 82m33.744s user 60m55.069s sys 3m3.375s 8.4 real 42m46.381s user 23m50.145s sys 2m9.853s When looking at a sample

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

On Nov 22, 2017, at 5:06 AM, Henrik Cednert (Filmlance) wrote: > > When investigating the zlib lead I looked at 8.4 installation and 9.5 > installation. 9.5 includes zlib.h (/Library/PostgreSQL//9.5/include/zlib.h), > but 8.4 doesn't. But that's a header file and

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

From: Henrik Cednert (Filmlance) [mailto:henrik.cedn...@filmlance.se] Sent: Tuesday, November 21, 2017 11:48 AM To: pgsql-performance@lists.postgresql.org Subject: Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade I VACUUM every sunday so that is done already. =/ Not sure I have the pro

pg_dump 3 times as slow after 8.4 -> 9.5 upgrade

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