Re: Index trouble with 8.3b4 - Mailing list pgsql-hackers

From Tom Lane
Subject Re: Index trouble with 8.3b4
Date
Msg-id 10977.1200269721@sss.pgh.pa.us
Whole thread Raw
In response to Re: Index trouble with 8.3b4  (Hannes Dorbath <light@theendofthetunnel.de>)
Responses Re: Index trouble with 8.3b4  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Hannes Dorbath <light@theendofthetunnel.de> writes:
> I have the bad feeling that I need to correct this into "It happens when 
> autovacuum is active on the table".

Ah-hah, I realize how to explain that too, now.  If you start the CREATE
INDEX CONCURRENTLY while an autovacuum is in progress on that table, the
autovacuum gets booted off so that C.I.C. can get the lock.  And, most
likely, it leaves the syncscan pointer positioned someplace past block
zero.  So the part that is a bit hard to reproduce is to launch the
C.I.C. while an autovacuum is in progress.
        regards, tom lane


pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Postgresql Materialized views
Next
From: Andrew Dunstan
Date:
Subject: Re: Postgresql Materialized views