Re: Question about caching on full table scans

Поиск
Список
Период
Сортировка
От Jeff Janes
Тема Re: Question about caching on full table scans
Дата
Msg-id CAMkU=1xZ822+Z06ZTFA8T+K8m1k4jh4tXvZuuv_cn=o+C_eTfA@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Question about caching on full table scans  (Markus Innerebner <markus.innerebner@inf.unibz.it>)
Список pgsql-performance
On Thu, Aug 30, 2012 at 10:34 AM, Markus Innerebner
<markus.innerebner@inf.unibz.it> wrote:
>
> > To flush the filesystem cache (from Linux 2.6.16 on), use
> > sync; echo 3 > /proc/sys/vm/drop_caches
>
>
> I started to do that , and
> yes, this solves my problem!!
>
> I assume that deleting file system cache implies that also postgres cache is
> deleted, isn't it ?


No, the postgres-managed cache is not cleared by doing that.  In order
to get rid of both layers of caching, you should restart the postgres
server and then do the drop_caches.

Cheers,

Jeff


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

Предыдущее
От: Markus Innerebner
Дата:
Сообщение: Re: Question about caching on full table scans
Следующее
От: Scott Marlowe
Дата:
Сообщение: Re: Question about caching on full table scans