Scott Marlowe wrote:
On Mon, 2004-08-02 at 02:11, Ioannis Theoharis wrote:
Hi, i would like to answer if there is any way in postgres to find the
page miss hits caused during a query execution.
Is there something like explain analyze with the page miss hits???
You're making a basic assumption that is (at least currently) untrue,
and that is that PostgreSQL has it's own cache.
Are you sure of this ? What is the meaning of the ARC recently introduced
then ?
Regards
Gaetano Mendola
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend