Re: Questions on query planner, join types, and work_mem

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