Re: Forcing using index instead of sequential scan?

Поиск
Список
Период
Сортировка
От Michael Stone
Тема Re: Forcing using index instead of sequential scan?
Дата
Msg-id 20060723110724.GU8069@mathom.us
обсуждение исходный текст
Ответ на Re: Forcing using index instead of sequential scan?  ("Craig A. James" <cjames@modgraph-usa.com>)
Ответы Re: Forcing using index instead of sequential scan?
Список pgsql-performance
On Sat, Jul 22, 2006 at 10:26:53AM -0700, Craig A. James wrote:
>This causes massive file-system activity and flushes all files that the
>kernel has cached.  If you run this between each Postgres test (let it run
>for a couple minutes), it gives you an apples-to-apples comparison between
>successive benchmarks, and eliminates the effects of caching.

Assuming a system with small ram or an unusually large system
installation. Unmounting is a much more realiable mechanism.

Mike Stone

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

Предыдущее
От: Mark Kirkwood
Дата:
Сообщение: Re: Forcing using index instead of sequential scan?
Следующее
От: "Craig A. James"
Дата:
Сообщение: Re: Forcing using index instead of sequential scan?