Scott Marlowe wrote:
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.
Can't tell if this is Linux or Windows from how the question was asked.
Here's h
On Thu, Dec 3, 2009 at 2:55 PM, Christine Penner
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
> pai
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
