Re: Index trouble with 8.3b4

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Index trouble with 8.3b4
Дата
Msg-id 11187.1200270668@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Index trouble with 8.3b4  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
I wrote;
> 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.

Hmm, no, scratch that: neither VACUUM nor ANALYZE use a standard
heapscan, so they won't move the syncscan pointer.  Were you performing
some other query that did a partial seqscan of the table?
        regards, tom lane


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Andrew Dunstan
Дата:
Сообщение: Re: Postgresql Materialized views
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: Distinguishing autovacuum activity in pg_stat_activity