Re: query plan question

Поиск
Список
Период
Сортировка
От David Parker
Тема Re: query plan question
Дата
Msg-id 07FDEE0ED7455A48AC42AC2070EDFF7C26B9D5@corpsrv2.tazznetworks.com
обсуждение исходный текст
Ответ на query plan question  ("David Parker" <dparker@tazznetworks.com>)
Ответы Re: query plan question  ("Matthew T. O'Connor" <matthew@zeut.net>)
Список pgsql-performance
We're using postgresql 7.4.5. I've only recently put pg_autovacuum in
place as part of our installation, and I'm basically taking the
defaults. I doubt it's a problem with autovacuum itself, but rather with
my configuration of it. I have some reading to do, so any pointers to
existing autovacuum threads would be greatly appreciated!

Thanks.

- DAP

>-----Original Message-----
>From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
>Sent: Wednesday, November 17, 2004 10:46 AM
>To: David Parker
>Cc: Jeff; Russell Smith; pgsql-performance@postgresql.org
>Subject: Re: [PERFORM] query plan question
>
>"David Parker" <dparker@tazznetworks.com> writes:
>> So I guess I need to figure out why pg_autovacuum isn't analyzing
>> those tables.
>
>Which autovacuum version are you using?  The early releases
>had some nasty bugs that would allow it to skip tables
>sometimes.  I think all the known problems are fixed as of
>recent 7.4.x updates.
>
>            regards, tom lane
>

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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: query plan question
Следующее
От: David Brown
Дата:
Сообщение: Analyzer is clueless