Needs Suggestion - Mailing list pgsql-general

From SUBHAM ROY
Subject Needs Suggestion
Date
Msg-id BANLkTim2YCN0duhVsDz6rYUrPjLztRfUyw@mail.gmail.com
Whole thread Raw
Responses Re: Needs Suggestion  (Andreas Kretschmer <akretschmer@spamfence.net>)
List 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.

pgsql-general by date:

Previous
From: Tian Luo
Date:
Subject: "full_page_writes" makes no difference?
Next
From: Andreas Kretschmer
Date:
Subject: Re: Needs Suggestion