Re: clearing the buffer cache

Поиск
Список
Период
Сортировка
От Chris Mayfield
Тема Re: clearing the buffer cache
Дата
Msg-id gnc34m$1eku$1@news.hub.org
обсуждение исходный текст
Ответ на Re: clearing the buffer cache  (Sam Mason <sam@samason.me.uk>)
Ответы Re: clearing the buffer cache  (Sam Mason <sam@samason.me.uk>)
Список pgsql-general
> With recent versions of Linux you can flush the system's buffer cache by
> doing:
>
>   # echo 3 > /proc/sys/vm/drop_caches

You can also try something like this:
http://wiki.services.openoffice.org/wiki/Cold-start-simulator

Shutting down the server and running fillmem has worked for me, but that
might take too long in your situation of thousands of small queries. But
I guess "SELECT * FROM large_table" would have taken just as long anyway.

--Chris

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

Предыдущее
От: Scara Maccai
Дата:
Сообщение: Re: left outer join without rows from "left" table
Следующее
От: Sam Mason
Дата:
Сообщение: Re: ask: select right(column) ???