Re: [HACKERS] reindex creates predicate lock on index root

2011-06-07 Thread Dan Ports
On Tue, Jun 07, 2011 at 07:45:43PM -0500, Kevin Grittner wrote: During testing of the SSI DDL changes I noticed that a REINDEX INDEX created a predicate lock on page 0 of the index. Really? That surprises me, and I couldn't reproduce it just now. Dan -- Dan R. K. Ports MIT CSAIL

Re: [HACKERS] reindex creates predicate lock on index root

2011-06-07 Thread Kevin Grittner
Dan Ports wrote: On Tue, Jun 07, 2011 at 07:45:43PM -0500, Kevin Grittner wrote: During testing of the SSI DDL changes I noticed that a REINDEX INDEX created a predicate lock on page 0 of the index. Really? That surprises me, and I couldn't reproduce it just now. You're right; that one

Re: [HACKERS] reducing the overhead of frequent table locks - now, with WIP patch

2011-06-07 Thread Bruce Momjian
Robert Haas wrote: On Mon, Jun 6, 2011 at 10:49 AM, Simon Riggs si...@2ndquadrant.com wrote: My point was that we have in the past implemented performance changes to increase scalability at the last minute, and also that our personal risk perspectives are not always set in stone. Robert

Re: [HACKERS] reducing the overhead of frequent table locks - now, with WIP patch

2011-06-07 Thread Bruce Momjian
Bruce Momjian wrote: Simon is right that we slipped the vxid patch into 8.3 when a Postgres user I talked to at Linuxworld mentioned high vacuum freeze activity and simple calculations showed the many read-only queries could cause high xid usage. Fortunately we already had a patch available

Re: [HACKERS] reducing the overhead of frequent table locks - now, with WIP patch

2011-06-07 Thread Tom Lane
Bruce Momjian br...@momjian.us writes: Simon is right that we slipped the vxid patch into 8.3 when a Postgres user I talked to at Linuxworld mentioned high vacuum freeze activity and simple calculations showed the many read-only queries could cause high xid usage. Fortunately we already had a

Re: [HACKERS] reindex creates predicate lock on index root

2011-06-07 Thread Alvaro Herrera
Excerpts from Kevin Grittner's message of mar jun 07 20:45:43 -0400 2011: During testing of the SSI DDL changes I noticed that a REINDEX INDEX created a predicate lock on page 0 of the index. Err, in a btree, page 0 is the metapage, not the root. The root page moves around, but it's never page

Re: [HACKERS] [Pgbuildfarm-members] CREATE FUNCTION hang on test machine polecat on HEAD

2011-06-07 Thread Tom Lane
Robert Creager robert.crea...@oracle.com writes: On Jun 7, 2011, at 3:01 PM, Tom Lane wrote: Robert Creager robert.crea...@oracle.com writes: configure:7158: checking for flags to link embedded Perl configure:7174: result: -L/usr/local/lib

Re: [HACKERS] Proposal: Another attempt at vacuum improvements

2011-06-07 Thread Pavan Deolasee
On Thu, May 26, 2011 at 4:10 PM, Pavan Deolasee pavan.deola...@gmail.com wrote: So are there any other objections/suggestions ? Anyone else cares to look at the brief design that we discussed above ? Otherwise, I would go ahead and work on this in the coming days. Of course, I will keep the

Re: [HACKERS] WALInsertLock contention

2011-06-07 Thread Merlin Moncure
On Wed, Feb 16, 2011 at 11:02 PM, Robert Haas robertmh...@gmail.com wrote: I've been thinking about the problem of $SUBJECT, and while I know it's too early to think seriously about any 9.2 development, I want to get my thoughts down in writing while they're fresh in my head. It seems to me

<    1   2