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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
