Quick Links

purge hash table, how to?

From:	huaxin zhang <uwcssa(at)gmail(dot)com>
To:	pgsql-hackers(at)postgresql(dot)org
Subject:	purge hash table, how to?
Date:	2005-09-06 18:37:52
Message-ID:	f2f5625105090611373dbbce1d@mail.gmail.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-hackers

i am using postgresql 8.0.3 as a single user by running "postgres"

I want to purge all contents in the bufferpool, and I did this by
calling "InitBufTable(256)" (buf_table.c) after each query. However,
this seems not working for each followup query I still get less disk read
(tracked by "smgrread()" in smgr.c) and increased bufferhitcount.

Could anyone tell me which module shall i modify instead?

In response to

Attention PL authors: want to be listed in template table? at 2005-09-06 00:24:19 from Tom Lane

Responses

Re: purge hash table, how to? at 2005-09-06 20:35:45 from Tom Lane

Browse pgsql-hackers by date

	From	Date	Subject
Next Message	Jim C. Nasby	2005-09-06 18:54:49	Re: Call for 7.5 feature completion
Previous Message	Martijn van Oosterhout	2005-09-06 18:31:45	Re: Mysteriously lost values in nodes