Re: R: slow seqscan after vacuum analize

Поиск
Список
Период
Сортировка
От David F. Skoll
Тема Re: R: slow seqscan after vacuum analize
Дата
Msg-id Pine.LNX.4.58.0402042115370.6678@shishi.roaringpenguin.com
обсуждение исходный текст
Ответ на R: slow seqscan after vacuum analize  ("Edoardo Ceccarelli" <eddy@axa.it>)
Ответы R: R: slow seqscan after vacuum analize
Список pgsql-admin
On Thu, 5 Feb 2004, Edoardo Ceccarelli wrote:

> Things are worst only for seqscan, when it uses indexscan timing is good.

It might just be that running VACUUM flushed the operating system's
buffer cache.

I always try running two or three EXPLAIN ANALYZE's in a row for the
same query.  Usually, the first one takes much longer than the rest.

Regards,

David.

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

Предыдущее
От: "Edoardo Ceccarelli"
Дата:
Сообщение: R: R: slow seqscan after vacuum analize
Следующее
От: "Edoardo Ceccarelli"
Дата:
Сообщение: R: R: slow seqscan after vacuum analize