Re: Optimizing >= and <= for numbers and dates

Поиск
Список
Период
Сортировка
От scott.marlowe
Тема Re: Optimizing >= and <= for numbers and dates
Дата
Msg-id Pine.LNX.4.33.0310011303350.22235-100000@css120.ihs.com
обсуждение исходный текст
Ответ на Re: Optimizing >= and <= for numbers and dates  ("Dimitri Nagiev" <dnagiev@gmx.de>)
Список pgsql-performance
Oh, to followup on my previously sent post, make sure you've got
effective_cache_size set right BEFORE you go trying to set
random_page_cost, and you might wanna run a select * from table to load
the table into kernel buffer cache before testing, then also test it with
the cache cleared out (select * from a_different_really_huge_table will
usually do that.)


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

Предыдущее
От: "scott.marlowe"
Дата:
Сообщение: Re: Optimizing >= and <= for numbers and dates
Следующее
От: Oleg Lebedev
Дата:
Сообщение: Re: TPC-R benchmarks