Re: shared_buffers advice

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Pierre C" <lists(at)peufeu(dot)com>
Cc: "Greg Smith" <greg(at)2ndquadrant(dot)com>, "Dave Crooke" <dcrooke(at)gmail(dot)com>, "Paul McGarry" <paul(at)paulmcgarry(dot)com>, pgsql-performance(at)postgresql(dot)org
Subject: Re: shared_buffers advice
Date: 2010-03-16 14:30:32
Message-ID: 8285.1268749832@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Pierre C" <lists(at)peufeu(dot)com> writes:
> Does PG issue checkpoint writes in "sorted" order ?

No. IIRC, a patch for that was submitted, and rejected because no
significant performance improvement could be demonstrated. We don't
have enough information about the actual on-disk layout to be very
intelligent about this, so it's better to just issue the writes and
let the OS sort them.

regards, tom lane

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Greg Stark 2010-03-16 14:51:11 Re: shared_buffers advice
Previous Message Pierre C 2010-03-16 13:48:43 Re: shared_buffers advice