Postgres Pro
Downloads
Home   >   mailing lists

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

From Hannes Dorbath
Subject Re: Index trouble with 8.3b4
Date
Msg-id 478A8D4A.7010603@theendofthetunnel.de
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
Tree view 
Hannes Dorbath wrote:
> Currently all I can say is: It happens the first time after I bulk load data into that table.

I have the bad feeling that I need to correct this into "It happens when 
autovacuum is active on the table".

Is it by any chance possible that CREATE INDEX CONCURRENTLY might read 
dirt while autovacuum is busy with the table?


-- 
Best regards,
Hannes Dorbath

pgsql-hackers by date:

Previous
From: "Guillaume Smet"
Date:
Subject: Re: Distinguishing autovacuum activity in pg_stat_activity
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Distinguishing autovacuum activity in pg_stat_activity