From: | Christopher Browne <cbbrowne(at)acm(dot)org> |
---|---|
To: | pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: Introducing an advanced Frequent Update Optimization |
Date: | 2006-11-09 21:47:22 |
Message-ID: | 87mz70gumt.fsf@wolfe.cbbrowne.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Quoth simon(at)2ndquadrant(dot)com ("Simon Riggs"):
> On Tue, 2006-11-07 at 15:00 +1300, Mark Kirkwood wrote:
>> Simon Riggs wrote:
>> > EnterpriseDB has been running a research project to improve the
>> > performance of heavily updated tables. We have a number of approaches
>> > prototyped and we'd like to discuss the best of these now on -hackers
>> > for community input and patch submission to PostgreSQL core.
>> >
>>
>> Excellent! It would certainly be good for use cases like:
>>
>> - session data from web (or similar) applications
>> - real time summary tables maintained by triggers
>>
>> to "just work", as (certainly in the case of the first one) quite a few
>> folks have been bitten by exactly the issue you describe.
>
> ...and of course it would be good if LISTEN/NOTIFY were able to use this
> concept also, to help Slony along also.
That should be much less relevant as people migrate to version 1.2, as
1.2 uses LISTEN/NOTIFY a whole lot less than earlier versions:
1. Number of events generated is cut in 1/2 because we don't
generate NOTIFIES for confirmations anymore
2. When a thread is busy, it shuts off LISTEN, and polls. That
will cut pg_listener bloat further...
--
let name="cbbrowne" and tld="gmail.com" in String.concat "@" [name;tld];;
http://cbbrowne.com/info/internet.html
"Ah, fall - when leaves turn to burnished colors upon darkling
branches, collars are turned up against a wind which murmurs of
winter, and homework assignments appear on Usenet. <sigh>"
-- Bob Jarvis
From | Date | Subject | |
---|---|---|---|
Next Message | Mark Dilger | 2006-11-09 22:41:35 | Re: plperl/plperlu interaction |
Previous Message | Josh Berkus | 2006-11-09 21:21:21 | Re: Frequent Update Project: Design Overview of HOT Updates |