Re: Disk access with fsync on.

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Bhide, Rajan" <rbhide(at)starentnetworks(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org
Subject: Re: Disk access with fsync on.
Date: 2005-12-12 15:13:41
Message-ID: 1846.1134400421@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

"Bhide, Rajan" <rbhide(at)starentnetworks(dot)com> writes:
> I would like to know the disk access mechanism for writing data with
> default fsync "on".

The only forced disk write (ie, the only thing you normally have to wait
for) is writing the WAL log entry/entries at "commit".

regards, tom lane

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Tom Lane 2005-12-12 15:21:48 Re: transaction ID wrap limit is 2147484146 Start Postgresql with error in Logfile
Previous Message Charley Tiggs 2005-12-12 13:51:53 Re: transaction ID wrap limit is 2147484146 Start Postgresql with error in Logfile