Re: PostgreSQL's query caching behaviour

Jan-Peter(dot)Seifert(at)gmx(dot)de wrote:
> Hello,
>
> I've a question regarding caching of results in the PostgreSQL-Server.
>
If you restart the server it will clear out the shared buffer pool, and
subsequent queries would show the appropriate delay.. You can clear out
the OS disk cache (on linux) using the commands:

sync
echo 1 > /proc/sys/vm/drop_caches

That's likely what you are missing.

--
Chander Ganesan
Open Technology Group, Inc.
One Copley Parkway, Suite 210
Morrisville, NC 27560
919-463-0999/877-258-8987
http://www.otg-nc.com
Expert PostgreSQL, PostGIS, MapServer, Python, PHP, Django and other Open Source Training.