Hi,
I would like to know the disk access mechanism for writing data with
default fsync "on".
I am using libpq client library to insert data to db server.
The insert query is typically done as a transaction with fsync "on"
i.e.:
begin;
insert into <tablename> values<values>;
end;
My query is how does it translate to disk access.
Does each insert writes to disk or to memory segment and a consolidated
write to disk, based on segment full or timeout.
I am using Postgres 7.4.5 on Sun Solaris 8.
Thanks,
-Rajan
"This email message and any attachments are confidential information of Starent Networks, Corp. The information
transmittedmay not be used to create or change any contractual obligations of Starent Networks, Corp. Any review,
retransmission,dissemination or other use of, or taking of any action in reliance upon this e-mail and its attachments
bypersons or entities other than the intended recipient is prohibited. If you are not the intended recipient, please
notifythe sender immediately -- by replying to this message or by sending an email to postmaster@starentnetworks.com --
anddestroy all copies of this message and any attachments without reading or disclosing their contents. Thank you."