Re: Questions on query planner, join types, and work_mem - Mailing list pgsql-performance

From Greg Smith
Subject Re: Questions on query planner, join types, and work_mem
Date
Msg-id 4C59D02E.7040908@2ndquadrant.com
Whole thread Raw
In response to Questions on query planner, join types, and work_mem  (Peter Hussey <peter@labkey.com>)
List pgsql-performance
Hannu Krosing wrote:
> Do you mean "written to disk", or written out from shared_buffers to
> disk cache ?
>

The later turns into the former eventually, so both really.  The kernel
will do some amount of write combining for you if you're lucky.  But not
in all cases; it may decide to write something out to physical disk
before the second write shows up.

--
Greg Smith  2ndQuadrant US  Baltimore, MD
PostgreSQL Training, Services and Support
greg@2ndQuadrant.com   www.2ndQuadrant.us


pgsql-performance by date:

Previous
From: Greg Smith
Date:
Subject: Re: Questions on query planner, join types, and work_mem
Next
From: "Kevin Grittner"
Date:
Subject: Re: Questions on query planner, join types, and work_mem