For portability's sake commit successful transactions and rollback those that fail. Rick pgsql-general-owner@xxxxxxxxxxxxxx wrote on 04/25/2005 05:53:11 PM: > "Dann Corbit" <DCorbit@xxxxxxxxx> writes: > > Probably, turning fsync off would be helpful, since you know it is > > read-only. > > Wouldn't make any difference: a transaction that hasn't modified the > database doesn't bother to write any commit/abort WAL record at all. > > regards, tom lane > > ---------------------------(end of broadcast)--------------------------- > TIP 3: if posting/reading through Usenet, please send an appropriate > subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your > message can get through to the mailing list cleanly ---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
