Re: Needs Suggestion

SUBHAM ROY <subham(dot)iem(at)gmail(dot)com> wrote:

> 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?

shared hit: read from shared mem
shared read: read from disk into shared mem

Andreas
--
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect. (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly." (unknown)
Kaufbach, Saxony, Germany, Europe. N 51.05082°, E 13.56889°