Re: [HACKERS] error: could not find pg_class tuple for index 2662

2011-07-31 Thread daveg
On Sun, Jul 31, 2011 at 11:44:39AM -0400, Tom Lane wrote: > daveg writes: > > Here is the update: the problem happens with vacuum full alone, no reindex > > is needed to trigger it. I updated the script to avoid reindexing after > > vacuum. Over the past two days there are still many ocurrances of

Re: [HACKERS] SSI heap_insert and page-level predicate locks

2011-07-31 Thread Jeff Davis
On Wed, 2011-06-08 at 17:29 -0500, Kevin Grittner wrote: > Heikki Linnakangas wrote: > > heap_insert() calls CheckForSerializableConflictIn(), which checks if > > there is a predicate lock on the whole relation, or on the page we're > > inserting to. It does not check for tuple-level locks, becaus

Re: [HACKERS] lazy vxid locks, v3

2011-07-31 Thread Jeff Davis
On Wed, 2011-07-20 at 13:41 -0400, Robert Haas wrote: > I took another look at v2 of my lazy vxid locks patch and realized > that it was pretty flaky in a couple of different ways. Here's a > version that I think is a bit more robust, but considering the extent > of the revisions, it probably need

Re: [HACKERS] python cleanup

2011-07-31 Thread Andrew Dunstan
On 07/25/2011 12:03 PM, Tom Lane wrote: Andrew Dunstan writes: On 07/25/2011 10:52 AM, Tom Lane wrote: What is features.h, and have its authors read the POSIX standard? AFAICS they have no business defining this symbol. [andrew@emma ~]$ rpm -q -f /usr/include/features.h glibc-head

Re: [HACKERS] libedit memory stomp is apparently fixed in OS X Lion

2011-07-31 Thread Dave Page
On Sun, Jul 31, 2011 at 6:45 PM, Alvaro Herrera wrote: > Excerpts from Dave Page's message of sáb jul 30 15:32:03 -0400 2011: >> On Sat, Jul 30, 2011 at 8:25 PM, Tom Lane wrote: >> > I think you had better plan on incorporating GNU readline into installer >> > builds for Lion. >> >> Unfortunately

Re: [HACKERS] libedit memory stomp is apparently fixed in OS X Lion

2011-07-31 Thread Alvaro Herrera
Excerpts from Dave Page's message of sáb jul 30 15:32:03 -0400 2011: > On Sat, Jul 30, 2011 at 8:25 PM, Tom Lane wrote: > > I think you had better plan on incorporating GNU readline into installer > > builds for Lion. > > Unfortunately the licence makes that a non-starter. A fixed version of lib

Re: [HACKERS] error: could not find pg_class tuple for index 2662

2011-07-31 Thread Tom Lane
daveg writes: > Here is the update: the problem happens with vacuum full alone, no reindex > is needed to trigger it. I updated the script to avoid reindexing after > vacuum. Over the past two days there are still many ocurrances of this > error coincident with the vacuum. Well, that jives with t

Re: [HACKERS] error: could not find pg_class tuple for index 2662

2011-07-31 Thread daveg
On Thu, Jul 28, 2011 at 11:31:31PM -0700, daveg wrote: > On Thu, Jul 28, 2011 at 07:45:01PM -0400, Robert Haas wrote: > > REINDEX. My guess is that this is happening either right around the > > time the VACUUM FULL commits or right around the time the REINDEX > > commits. It'd be helpful to know