Re: Inserts optimization?

From: Francisco Reyes <lists(at)stringsutils(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
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 17:50:30
Message-ID: cone.1145037030.537508.283.5001@35st-server.simplicato.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Tom Lane writes:

> That will help not at all, if the problem is too-short transactions
> as it sounds to be.

How about commit_delay?

> You really need to pester the authors of bacula
> to try to wrap multiple inserts per transaction.

Like any volunteer project I am sure it's more an issue of resources than an
issue of interest.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Christian Storm 2006-04-14 18:01:10 Re: pgmemcache
Previous Message Tom Lane 2006-04-14 16:58:49 Re: merge>hash>loop