fsync vs open_sync - Mailing list pgsql-hackers

From pgsql@mohawksoft.com
Subject fsync vs open_sync
Date
Msg-id 4201.64.119.142.34.1092075497.squirrel@mail.mohawksoft.com
Whole thread Raw
List pgsql-hackers
I did a little test on the various options of fsync.

I'm not sure my tests are scientific enough for general publication or
evaluation, all I am doing is performaing a loop that inserts a value into
a table 1 million times.
create table testndx (value integer, name varchar);
create index testndx_val on testndx (value);

for(int i=0; i < 1000000; i++)
{  insert into testndx (value, name) values ('%d', 'test')




pgsql-hackers by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: Beta Leader?
Next
From: pgsql@mohawksoft.com
Date:
Subject: fsync vs open_sync