I am puzzled about the extent to which shared_bufferes is used for
different queries. Do _all_ queries "touch" shared buffers at some point
of their execution?
Many of our warehouse queries are seq_scan followed by HASH. I know
work_mem is assigned for HASH joins: but does this mean that thes
cally what is the anatomy of a hash join involving large tables?
Disk->Shared_Buffers->Hash Join areas? something like that?
On Sun, Dec 29, 2013 at 9:18 AM, Michael Paquier
wrote:
> On Sun, Dec 29, 2013 at 9:05 PM, Shiv Sharma
> wrote:
> > I am puzzled about the extent to which
