Re: why do optimizer parameters have to be set manually?

Поиск
Список
Период
Сортировка
От William Yu
Тема Re: why do optimizer parameters have to be set manually?
Дата
Msg-id brvddd$1u7p$1@news.hub.org
обсуждение исходный текст
Ответ на Re: why do optimizer parameters have to be set manually?  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
Tom Lane wrote:
> easy or cheap to get a measurement that isn't skewed by kernel caching
> behavior.  (You need a test file significantly larger than RAM, and
> even then you'd better repeat the measurement quite a few times to see
> how much noise there is in it.)

I found a really fast way in Linux to flush the kernel cache and that is
to unmount the drive and then remount. Beats having to read though a
file > RAM everytime.


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