Needs Suggestion

From: SUBHAM ROY <subham(dot)iem(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Needs Suggestion
Date: 2011-05-04 05:40:10
Message-ID: BANLkTim2YCN0duhVsDz6rYUrPjLztRfUyw@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

My output of explain (analyze,buffers) is something like this:

shared hit=3796624 read=46038

So what is meant by *read* here? Does it indicates number of disk reads?

Does *shared hit* takes into account only the hit in the pg_buffercache of
the postgres or it also takes into account the *linux buffers* that postgres
uses?

--
Thank You,
Subham Roy,
CSE IIT Bombay.

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andreas Kretschmer 2011-05-04 06:39:12 Re: Needs Suggestion
Previous Message Jesper Krogh 2011-05-04 05:33:25 Re: [PERFORMANCE] expanding to SAN: which portion best to move