SUBHAM ROY <subham.iem@gmail.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°