Re: Index trouble with 8.3b4

From: Hannes Dorbath <light(at)theendofthetunnel(dot)de>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Subject: Re: Index trouble with 8.3b4
Date: 2008-01-13 22:14:34
Message-ID: 478A8D4A.7010603@theendofthetunnel.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Satch Jones 2008-01-13 23:32:31 tsearch2 install on Fedora Core 5 problems
Previous Message x asasaxax 2008-01-13 21:55:58 Satisfactory Query Time

Browse pgsql-hackers by date

  From Date Subject
Next Message Joshua D. Drake 2008-01-13 22:27:48 Re: Distinguishing autovacuum activity in pg_stat_activity
Previous Message Guillaume Smet 2008-01-13 22:14:32 Re: Distinguishing autovacuum activity in pg_stat_activity