Postgres Pro
Downloads
Home   >   mailing lists

Re: Disk access with fsync on. - Mailing list pgsql-novice

From Tom Lane
Subject Re: Disk access with fsync on.
Date
Msg-id 1846.1134400421@sss.pgh.pa.us
Whole thread Raw
In response to Disk access with fsync on.  ("Bhide, Rajan" <rbhide@starentnetworks.com>)
List pgsql-novice
Tree view 
"Bhide, Rajan" <rbhide@starentnetworks.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

pgsql-novice by date:

Previous
From: Charley Tiggs
Date:
Subject: Re: transaction ID wrap limit is 2147484146 Start Postgresql with error in Logfile
Next
From: Tom Lane
Date:
Subject: Re: transaction ID wrap limit is 2147484146 Start Postgresql with error in Logfile