Re: [HACKERS] Backport of fsync queue compaction

2012-06-26 Thread Robert Haas
On Tue, Jun 19, 2012 at 5:39 PM, Robert Haas robertmh...@gmail.com wrote: On Tue, Jun 19, 2012 at 5:33 PM, Greg Smith g...@2ndquadrant.com wrote: In January of 2011 Robert committed 7f242d880b5b5d9642675517466d31373961cf98 to try and compact the fsync queue when clients find it full.  There's

Re: [HACKERS] Backport of fsync queue compaction

2012-06-20 Thread Greg Smith
I don't want to take a bunch of time away from the active CF talking about this, just wanted to pass along some notes: -Back branch release just happening a few weeks ago. Happy to have this dropped until the CF is over. -Attached is a working backport of this to 8.4, with standard git

Re: [HACKERS] Backport of fsync queue compaction

2012-06-19 Thread Robert Haas
On Tue, Jun 19, 2012 at 5:33 PM, Greg Smith g...@2ndquadrant.com wrote: In January of 2011 Robert committed 7f242d880b5b5d9642675517466d31373961cf98 to try and compact the fsync queue when clients find it full.  There's no visible behavior change, just a substantial performance boost possible

Re: [HACKERS] Backport of fsync queue compaction

2012-06-19 Thread Christopher Browne
On Tue, Jun 19, 2012 at 5:39 PM, Robert Haas robertmh...@gmail.com wrote: On Tue, Jun 19, 2012 at 5:33 PM, Greg Smith g...@2ndquadrant.com wrote: In January of 2011 Robert committed 7f242d880b5b5d9642675517466d31373961cf98 to try and compact the fsync queue when clients find it full.  There's

Re: [HACKERS] Backport of fsync queue compaction

2012-06-19 Thread Alvaro Herrera
Excerpts from Robert Haas's message of mar jun 19 17:39:46 -0400 2012: On Tue, Jun 19, 2012 at 5:33 PM, Greg Smith g...@2ndquadrant.com wrote: In January of 2011 Robert committed 7f242d880b5b5d9642675517466d31373961cf98 to try and compact the fsync queue when clients find it full.  There's

Re: [HACKERS] Backport of fsync queue compaction

2012-06-19 Thread Andres Freund
On Tuesday, June 19, 2012 11:39:46 PM Robert Haas wrote: On Tue, Jun 19, 2012 at 5:33 PM, Greg Smith g...@2ndquadrant.com wrote: In January of 2011 Robert committed 7f242d880b5b5d9642675517466d31373961cf98 to try and compact the fsync queue when clients find it full. There's no visible

Re: [HACKERS] Backport of fsync queue compaction

2012-06-19 Thread Josh Berkus
To what version will we backport it? -- Josh Berkus PostgreSQL Experts Inc. http://pgexperts.com -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers

Re: [HACKERS] Backport of fsync queue compaction

2012-06-19 Thread Robert Haas
On Tue, Jun 19, 2012 at 7:33 PM, Josh Berkus j...@agliodbs.com wrote: To what version will we backport it? All supported branches, I would think. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list

Re: [HACKERS] Backport of fsync queue compaction

2012-06-19 Thread Greg Smith
On 06/19/2012 08:41 PM, Robert Haas wrote: On Tue, Jun 19, 2012 at 7:33 PM, Josh Berkusj...@agliodbs.com wrote: To what version will we backport it? All supported branches, I would think. Yeah, I would feel a lot better if this was improved in 8.3 and up. I didn't bother trying to push