Horton

Re: RE: [COMMITTERS] pgsql/src/backend/access/transam ( xact.c xlog.c)

Don Baccus <dhogaza@pacifier.com>

View thread
From: Don Baccus <dhogaza@pacifier.com>
To: Alfred Perlstein <bright@wintelcom.net>, Bruce Momjian <pgman@candle.pha.pa.us>
Cc: Vadim Mikheev <vmikheev@sectorbase.com>, "'Tom Lane'" <tgl@sss.pgh.pa.us>, Tatsuo Ishii <t-ishii@sra.co.jp>, peter_e@gmx.net, pgsql-hackers@postgresql.org
Date: 2000-11-16T17:58:53Z
Lists: pgsql-hackers 
At 09:32 AM 11/16/00 -0800, Alfred Perlstein wrote:
>* Bruce Momjian <pgman@candle.pha.pa.us> [001116 08:59] wrote:

>> Ewe, so we have this 1/200 second delay for every transaction.  Seems
>> bad to me.
>
>I think as long as it becomes a tunable this isn't a bad idea at
>all.  Fixing it at 1/200 isn't so great because people not wrapping
>large amounts of inserts/updates with transaction blocks will
>suffer.

I think the default should probably be no delay, and the documentation
on enabling this needs to be clear and obvious (i.e. hard to miss).



- Don Baccus, Portland OR <dhogaza@pacifier.com>
  Nature photos, on-line guides, Pacific Northwest
  Rare Bird Alert Service and other goodies at
  http://donb.photo.net.