Re: CommitDelay performance improvement - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: CommitDelay performance improvement
Date
Msg-id 200102240403.XAA17478@candle.pha.pa.us
Whole thread Raw
In response to Re: CommitDelay performance improvement  (Philip Warner <pjw@rhyme.com.au>)
List pgsql-hackers
> At 21:31 23/02/01 -0500, Bruce Momjian wrote:
> >Now, I know many will complain that we are returning commit while not
> >having the stuff on the platter. 
> 
> You're definitely right there.
> 
> >Maybe they do, but it seems
> >the benefit of grouped fsyncs() is large enough that many will say they
> >would rather have this option.
> 
> I'd prefer to wait for a lock manager that supports timeouts and contention
> notification.

I understand, and if that was going to fix the problem completely, but
it isn't.  It is just going to allow us more flexibility at guessing who
may be about to commit.

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026
 


pgsql-hackers by date:

Previous
From: "Schmidt, Peter"
Date:
Subject: RE: Re: [ADMIN] v7.1b4 bad performance
Next
From: "Diehl, Jeffrey"
Date:
Subject: RE: [SQL] handling of database size exceeding physical disk space