Re: Removing freelist (was Re: Should I implement DROP INDEX CONCURRENTLY?)
Simon Riggs <simon@2ndquadrant.com>
From: Simon Riggs <simon@2ndQuadrant.com>
To: Robert Haas <robertmhaas@gmail.com>
Cc: Tom Lane <tgl@sss.pgh.pa.us>, Jim Nasby <jim@nasby.net>, Heikki Linnakangas <heikki.linnakangas@enterprisedb.com>, Daniel Farina <daniel@heroku.com>, Merlin Moncure <mmoncure@gmail.com>, pgsql-hackers <pgsql-hackers@postgresql.org>
Date: 2012-01-23T13:16:14Z
Lists: pgsql-hackers
On Mon, Jan 23, 2012 at 1:06 PM, Robert Haas <robertmhaas@gmail.com> wrote: > It's pretty trivial to prove that there is a very serious problem with > BufFreelistLock. I'll admit I can't prove what the right fix is just > yet, and certainly measurement is warranted. I agree there is a problem with BufFreelistLock (so please share your results with Heikki, who seems not to). As a result, I've published patches which reduce contention on that lock in various ways, all of which seem valid to me. There are lots of things we could have done for 9.2 but didn't, yet we have some things that did get done on the table right now so it would be useful to push those through immediately or at least defer discussion on other things until we get back around to this. -- Simon Riggs http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services