pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Matthew Hall <mhall@mhcomputing.net>
To: Henrik Cednert (Filmlance) <henrik.cednert@filmlance.se>
Cc: pgsql-performance@lists.postgresql.org <pgsql-performance@lists.postgresql.org>
Subject: Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade
Date: Wed, 22 Nov 2017 11:52:11 -0800
Message-ID: <ADC5D88A-5486-4075-B99F-80102F6DA681@mhcomputing.net> (raw)
In-Reply-To: <12D87F70-956E-499B-9532-DAC52F419837@filmlance.se>
References: <8F33D0C7-E12E-4996-990C-3CF0C5ED0437@filmlance.se>
	<7442.1511283687@sss.pgh.pa.us>
	<CA+TgmoY3F+Yiheh-41wuLVzozw9sKQFqBG2fqSbskKvL20tFrw@mail.gmail.com>
	<14231.1511289969@sss.pgh.pa.us>
	<2D863ADA-134E-414B-82DD-88E53D621697@filmlance.se>
	<20863.1511298080@sss.pgh.pa.us>
	<13B8A868-BB94-4A4B-81AF-EB3DCC379439@filmlance.se>
	<8337E0CC-47A3-4A5F-8156-31BE1E1F0484@filmlance.se>
	<C5EC3C9D-755B-4356-B1EB-7822030D03A2@mhcomputing.net>
	<73DE6D60-EB64-42D8-B57F-538C617CEA23@filmlance.se>
	<12D87F70-956E-499B-9532-DAC52F419837@filmlance.se>

On Nov 22, 2017, at 5:06 AM, Henrik Cednert (Filmlance) <henrik.cednert@filmlance.se> 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 I have no idea how that really works and if that's the one used by pgres9.5 or not. The version in it says 1.2.8 and that's what the Instruments are showing when I monitor pg_dump while running. 
> 
> Guess I'll have to install instruments in a dev env and do a pg_dump with 8.4 to see the difference. Tedious. =/ 

I would also check the library linkages of the pg_dump binaries.

See if one thing is using an embedded zlib and the other a system zlib.

Then you could imagine one didn't get compiled with the best-performing CFLAGS, etc.

Matthew.



view thread (28+ messages)  latest in thread

Message-ID: <ADC5D88A-5486-4075-B99F-80102F6DA681@mhcomputing.net>
Permalink:  ../ADC5D88A-5486-4075-B99F-80102F6DA681@mhcomputing.net/
Also on:    postgresql.org/message-id/ADC5D88A-5486-4075-B99F-80102F6DA681@mhcomputing.net

 · 

reply
Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: pgsql-performance@postgresql.org
  Cc: mhall@mhcomputing.net, henrik.cednert@filmlance.se, pgsql-performance@lists.postgresql.org
  Subject: Re: pg_dump 3 times as slow after 8.4 -> 9.5 upgrade
  In-Reply-To: <ADC5D88A-5486-4075-B99F-80102F6DA681@mhcomputing.net>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox