fsync vs open_sync

From: pgsql(at)mohawksoft(dot)com
To: pgsql-hackers(at)postgresql(dot)org
Subject: fsync vs open_sync
Date: 2004-08-09 18:18:17
Message-ID: 4201.64.119.142.34.1092075497.squirrel@mail.mohawksoft.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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')

Browse pgsql-hackers by date

  From Date Subject
Next Message pgsql 2004-08-09 18:27:00 fsync vs open_sync
Previous Message Alvaro Herrera 2004-08-09 18:10:54 Re: VACUUM DELAY