Re: Query results caching?

> -----Original Message-----
> From: pgsql-general-owner(at)postgresql(dot)org [mailto:pgsql-general-
> owner(at)postgresql(dot)org] On Behalf Of Ben-Nes Yonatan
> Sent: Monday, August 22, 2005 9:03 AM
> To: pgsql-general(at)postgresql(dot)org
> Subject: [GENERAL] Query results caching?
>
> Hi all,
>
> I dont know how its called but I noticed that when I query the db for
> the first time it give me the result slower then the next times ill
> repeat the same exact query, I figure that its some kind of caching so
> henceforth the title of the mail :)

The operating system and the database will both percolate frequently
used information from disk into memory. Particularly if they are SELECT
queries, they will get faster and faster.

> Anyway I would want to be able to delete that "caching" after every
> query test that I run, cause I want to see the real time results for
my
> queries (its for a searching option for users so it will vary alot).

Those are the real times for your queries.

> Is it possible to do it manually each time or maybe only from the
> configuration?

You will have to query a different table each time.

> Thanks in advance,
> Ben-Nes Yonatan
> Canaan Surfing ltd.
> http://www.canaan.net.il
>
> ---------------------------(end of
broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster