Re: Inserts optimization?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Francisco Reyes <lists(at)stringsutils(dot)com>
Cc: Marc Cousin <mcousin(at)sigma(dot)fr>, Chris <dmagick(at)gmail(dot)com>, Pgsql performance <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Inserts optimization?
Date: 2006-04-14 16:30:19
Message-ID: 10151.1145032219@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Francisco Reyes <lists(at)stringsutils(dot)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

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Ian Westmacott 2006-04-14 16:45:48 Re: merge>hash>loop
Previous Message Tom Lane 2006-04-14 16:13:25 Re: merge>hash>loop