Re: How i can empty the buffers of a db

On Fri, Aug 02, 2002 at 06:29:33PM +0300, Tourtounis Sotiris wrote:
> I am sorry for my lack of good knowledge of English but i have previously
> asked how during a session with the database server to empty the memory
> buffers after any commited select/insert/delete in order to have an as
> much as possible indicative execution time and explain facility for each
> of them. Thank you for your willingness of help !!!

Ah, then you don't want to empty the buffers. Just make sure fsync
is turned on (if it is, fsync _must_ be called before your
transaction COMMITs). To see some statistics, try turing on query
stats or executor stats. See

<http://www.postgresql.org/idocs/index.php?runtime-config.html#LOGGING>

A

--
----
Andrew Sullivan 87 Mowat Avenue
Liberty RMS Toronto, Ontario Canada
<andrew(at)libertyrms(dot)info> M6K 3E3
+1 416 646 3304 x110