Re: Estimating seq_page_fetch and random_page_fetch

Поиск
Список
Период
Сортировка
От Neil Conway
Тема Re: Estimating seq_page_fetch and random_page_fetch
Дата
Msg-id 1173393578.6422.7.camel@localhost.localdomain
обсуждение исходный текст
Ответ на Re: Estimating seq_page_fetch and random_page_fetch  (Gregory Stark <stark@enterprisedb.com>)
Список pgsql-hackers
On Thu, 2007-03-08 at 17:35 +0000, Gregory Stark wrote:
> When I was running tests I did it on a filesystem where nothing else was
> running. Between tests I unmounted and remounted it. As I understand it Linux
> associates the cache with the filesystem and not the block device and discards
> all pages from cache when the filesystem is unmounted.

On recent Linux kernels, /proc/sys/vm/drop_caches can also be useful:
   http://linux.inet.hr/proc_sys_vm_drop_caches.html

You could also use posix_fadvise() to achieve a similar effect on a per-file
basis.

-Neil




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

Предыдущее
От: Shane Ambler
Дата:
Сообщение: Re: Auto creation of Partitions
Следующее
От: Gavin Sherry
Дата:
Сообщение: Re: Stream bitmaps