Re: vacuum locking

Поиск
Список
Период
Сортировка
От scott.marlowe
Тема Re: vacuum locking
Дата
Msg-id Pine.LNX.4.33.0310301054360.23412-100000@css120.ihs.com
обсуждение исходный текст
Ответ на Re: vacuum locking  (Rob Nagler <nagler@bivio.biz>)
Список pgsql-performance
On Thu, 30 Oct 2003, Rob Nagler wrote:

> scott.marlowe writes:
> > t2 was 'vacuum full'ed and analyzed, right?  Just guessing.
>
> Fresh import.  I've been told this includes a ANALYZE.

You should probably run analyze by hand just to be sure.  If the planner
is using an index scan on a table with 20 rows, then it's likely it has
the default statistics for the table, not real ones.


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

Предыдущее
От: "scott.marlowe"
Дата:
Сообщение: Re: vacuum locking
Следующее
От: Greg Stark
Дата:
Сообщение: Re: Query puts 7.3.4 on endless loop but 7.4beta5 is fine.