On Sun, Nov 7, 2010 at 4:13 PM, Greg Smith wrote:
> Jeff Janes wrote:
>
>> Assuming the ordering is useful, the only way the OS can do as good a
>> job as the checkpoint code can, is if the OS stores the entire
>> checkpoint worth of data as dirty blocks and doesn't start writing
>> until an fsync
Jeff Janes wrote:
Assuming the ordering is useful, the only way the OS can do as good a
job as the checkpoint code can, is if the OS stores the entire
checkpoint worth of data as dirty blocks and doesn't start writing
until an fsync comes in. This strikes me as a pathologically
configured OS/FS
On Sat, Nov 6, 2010 at 7:25 PM, Jeff Janes wrote:
>> There are really two separate things here:
>>
>> (1) trying to do all the writes to file A before you start doing
>> writes to file B, and
>> (2) trying to write out blocks to each file in ascending logical block
>> number order
>>
>> I'm much m
On Fri, Oct 29, 2010 at 6:17 AM, Robert Haas wrote:
> On Fri, Oct 29, 2010 at 2:58 AM, Itagaki Takahiro
> wrote:
>> On Fri, Oct 29, 2010 at 3:23 PM, Heikki Linnakangas
>> wrote:
>>> Simon's argument in the thread that the todo item points to
>>> (http://archives.postgresql.org/pgsql-patches/2008
Itagaki Takahiro wrote:
When I submitted the patch, I tested it on disk-based RAID-5 machine:
http://archives.postgresql.org/pgsql-hackers/2007-06/msg00541.php
But there were no additional benchmarking reports at that time. We still
need benchmarking before we re-examine the feature. For example,
Heikki Linnakangas writes:
> Simon's argument in the thread that the todo item points to
> (http://archives.postgresql.org/pgsql-patches/2008-07/msg00123.php) is
> basically that we don't know what the best algorithm is yet and
> benchmarking is a lot of work, so let's just let people do whatev
On Fri, Oct 29, 2010 at 2:58 AM, Itagaki Takahiro
wrote:
> On Fri, Oct 29, 2010 at 3:23 PM, Heikki Linnakangas
> wrote:
>> Simon's argument in the thread that the todo item points to
>> (http://archives.postgresql.org/pgsql-patches/2008-07/msg00123.php) is
>> basically that we don't know what the
On Fri, Oct 29, 2010 at 3:23 PM, Heikki Linnakangas
wrote:
> Simon's argument in the thread that the todo item points to
> (http://archives.postgresql.org/pgsql-patches/2008-07/msg00123.php) is
> basically that we don't know what the best algorithm is yet and benchmarking
> is a lot of work, so le
On 29.10.2010 06:00, Jeff Janes wrote:
One of the items on the Wiki ToDo list is sorted writes for
checkpoints. The consensus seemed to be that this should be done by
adding hook(s) into the main code, and then a contrib module to work
with those hooks. Is there an existing contrib module that
Excerpts from Jeff Janes's message of vie oct 29 00:00:24 -0300 2010:
> One of the items on the Wiki ToDo list is sorted writes for
> checkpoints. The consensus seemed to be that this should be done by
> adding hook(s) into the main code, and then a contrib module to work
> with those hooks. Is t
One of the items on the Wiki ToDo list is sorted writes for
checkpoints. The consensus seemed to be that this should be done by
adding hook(s) into the main code, and then a contrib module to work
with those hooks. Is there an existing contrib module that one could
best look to for inspiration on
11 matches
Mail list logo