> -----Original Message----- > From: [EMAIL PROTECTED] [mailto:pgsql-general- > [EMAIL PROTECTED] On Behalf Of Ben-Nes Yonatan > Sent: Monday, August 22, 2005 9:03 AM > To: pgsql-general@postgresql.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 ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
