Re: 8.4 open item: copy performance regression? - Mailing list pgsql-hackers

From Greg Smith
Subject Re: 8.4 open item: copy performance regression?
Date
Msg-id alpine.GSO.2.01.0906221626500.2428@westnet.com
Whole thread Raw
In response to Re: 8.4 open item: copy performance regression?  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
Responses Re: 8.4 open item: copy performance regression?  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-hackers
On Mon, 22 Jun 2009, Kevin Grittner wrote:

> When I tried with setting the ring size to 16MB, I accidentally left off 
> the step to copy the postgresql.conf file, and got better performance.

Do you have happen to have a build with assertions turned on?  That is one 
common cause of performance going down via increased shared_buffers that 
people tend to run into during beta.

You can check via psql with
  show debug_assertions;

--
* Greg Smith gsmith@gregsmith.com http://www.gregsmith.com Baltimore, MD


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: 8.4 open item: copy performance regression?
Next
From: "Kevin Grittner"
Date:
Subject: Re: 8.4 open item: copy performance regression?