On Thu, Aug 30, 2012 at 10:34 AM, Markus Innerebner <markus.innereb...@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 -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
