Chris Angelico wrote: >> - Set fsync=off and hope you don't crash. > > Ouch. I might consider that for a bulk import operation or something, > but not for live usage. There's plenty else can be done without > risking data corruption.
I didn't mean that to be an alternative that anybody should consider for production use. I don't think that there are so many ways to speed up INSERTs. Can you think of some that I have missed? Yours, Laurenz Albe -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
