Re: commit_delay, siblings

Tom Lane wrote:
> Josh Berkus <josh@agliodbs.com> writes:
> 
>>I've been trying to get a test result for 8.1 that shows that we can eliminate 
>>commit_delay and commit_siblings, as I believe that these settings no longer 
>>have any real effect on performance.
> 
> 
> I don't think they ever did :-(.  The theory is good, but useful values
> for commit_delay would probably be under a millisecond, and there isn't
> any portable way to sleep for such short periods.  We've been leaving
> them there just in case somebody can find a use for 'em, but I wouldn't
> object to taking them out.
> 
>             regards, tom lane
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)


We have done extensive testing some time ago.
We could not see any difference on any platform we have tested (AIX, 
Linux, Solaris). I don't think that there is one at all - at least not 
on common systems.
best regards,
    hans

-- 
Cybertec Geschwinde u Schoenig
Schoengrabern 134, A-2020 Hollabrunn, Austria
Tel: +43/664/393 39 74
www.cybertec.at, www.postgresql.at