Re: Performance lossage in checkpoint dumping

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: The Hermit Hacker <scrappy(at)hub(dot)org>
Cc: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org, "Vadim B(dot) Mikheev" <vadim4o(at)email(dot)com>
Subject: Re: Performance lossage in checkpoint dumping
Date: 2001-02-17 05:24:25
Message-ID: 2696.982387465@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

The Hermit Hacker <scrappy(at)hub(dot)org> writes:
> No way to group the writes to you can keep the most recent one open?
> Don't see an easy way, do you?
>>
>> No, but I haven't looked at it. I am now much more concerned with the
>> delay,

I concur. The blind write business is not important enough to hold up
the release for --- for one thing, it has nothing to do with the pgbench
results we're seeing, because these tests don't run long enough to
include any checkpoint cycles. The commit delay, on the other hand,
is a big problem.

>> and am wondering if I should start thinking about trying my idea
>> of looking for near-committers and post the patch to the list to see if
>> anyone likes it for 7.1 final. Vadim will not be back in enough time to
>> write any new code in this area, I am afraid.

> Near committers? *puzzled look*

Processes nearly ready to commit. I'm thinking that any mechanism for
detecting that might be overkill, however, especially compared to just
setting commit_delay to zero by default.

I've been sitting here running pgbench under various scenarios, and so
far I can't find any condition where commit_delay>0 is materially better
than commit_delay=0, even under heavy load. It's either the same or
much worse. Numbers to follow...

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2001-02-17 05:27:34 Re: beta5 ...
Previous Message Tatsuo Ishii 2001-02-17 05:18:42 Re: beta5 ...