Re: Inserts optimization? - Mailing list pgsql-performance

From Tom Lane
Subject Re: Inserts optimization?
Date
Msg-id 10151.1145032219@sss.pgh.pa.us
Whole thread Raw
In response to Re: Inserts optimization?  (Francisco Reyes <lists@stringsutils.com>)
List pgsql-performance
Francisco Reyes <lists@stringsutils.com> writes:
> I think I am going to try increasing wal_buffers

That will help not at all, if the problem is too-short transactions
as it sounds to be.  You really need to pester the authors of bacula
to try to wrap multiple inserts per transaction.  Or maybe find some
other software that can do that, if they are uninterested in supporting
anything but mysql.

            regards, tom lane

pgsql-performance by date:

Previous
From: Tom Lane
Date:
Subject: Re: merge>hash>loop
Next
From: Ian Westmacott
Date:
Subject: Re: merge>hash>loop