Re: [HACKERS] [RFC] Common object property boards

2011-07-31 Thread Kohei KaiGai
2011/7/29 Tom Lane t...@sss.pgh.pa.us: Kohei Kaigai kohei.kai...@emea.nec.com writes: In addition to this suggestion, I think the big static array also contains the following items: - Text form of the object type (e.g, table, function, ...) What will you do with that that wouldn't be better

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 which,

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

2011-07-31 Thread Tom Lane
daveg da...@sonic.net 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

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 t...@sss.pgh.pa.us 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

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 alvhe...@commandprompt.com 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 t...@sss.pgh.pa.us wrote: I think you had better plan on incorporating GNU readline into installer

Re: [HACKERS] python cleanup

2011-07-31 Thread Andrew Dunstan
On 07/25/2011 12:03 PM, Tom Lane wrote: Andrew Dunstanand...@dunslane.net 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

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 needs

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 heikki.linnakan...@enterprisedb.com 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

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 da...@sonic.net 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