Re: Inserts optimization?

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Magnus Hagander" <mha(at)sollentuna(dot)net>
Cc: "Markus Schaber" <schabi(at)logix-tt(dot)com>, "Pgsql performance" <pgsql-performance(at)postgresql(dot)org>
Subject: Re: Inserts optimization?
Date: 2006-04-19 15:14:52
Message-ID: 26312.1145459692@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

"Magnus Hagander" <mha(at)sollentuna(dot)net> writes:
>>> Actually, [commit_delay] might well hurt by introducing extra delays.
>>
>> Well, if you read the documentation, you will see that it
>> will only wait if there are at least commit_siblings other
>> transactions active. So when Bacula serializes access, there
>> will be no delays, as there is only a single transaction alive.

> Hm. Right. Well, it still won't help :-)

It could actually hurt, because nonzero time is required to go look
whether there are any other active transactions. I'm not sure whether
this overhead is enough to be measurable when there's only one backend
running, but it might be.

regards, tom lane

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Scott Marlowe 2006-04-19 15:22:10 Re: Inserts optimization?
Previous Message Markus Schaber 2006-04-19 12:50:26 Re: Inserts optimization?