On Thu, Dec 3, 2009 at 2:55 PM, Christine Penner <christ...@ingenioussoftware.com> wrote: > Hi, > > The first time I use a query its much slower than the second, third etc. I > want to do some testing with the 1st (slower) time. The only way I have > found to reproduce that slow time is to restart my computer which is a huge > pain. Is there a better way to clear whatever Postgres is holding to make > them faster. I have tried restarting the Postgres service but that doesn't > help.
Restarting pgsql accomplishes the same thing as regards pgsql. BUT most OSes also cache, so you need a way to flush the kernel / file system cache. That depends on which OS you're running. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
