Suvankar Roy wrote:
> Actually I am trying to figure out how much execution time any query
> is taking is taking when executed for the first time.
>
> Because once a query is executed for the first time, the query plan,
> data buffer is cached so subsequently time taken is much lower.
>
> For
the Shared buffer cache flushed to note the
initial execution time.
Is my understanding correct here ?
Regards,
Suvankar Roy
Chander Ganesan
07/15/2009 08:48 PM
To
Suvankar Roy
cc
pgsql-admin@postgresql.org
Subject
Re: [ADMIN] Flush Shared Buffer Cache
Suvankar Roy wrote:
>
&
Suvankar Roy wrote:
Hi,
Can anyone help me out with how to flush out Shared Buffer Cache in
Postgres.
One way would be to restart the database, but I would like to avoid that.
AFAIK, that's the only way.
Is there a reason that you need to dump the shared buffers? Perhaps if
we knew what
Hi,
Can anyone help me out with how to flush out Shared Buffer Cache in
Postgres.
One way would be to restart the database, but I would like to avoid that.
Regards,
Suvankar Roy
=-=-=
Notice: The information contained in this e-mail
message and/or attachments to it may cont
