Re: Introducing an advanced Frequent Update Optimization

From: Mark Kirkwood <markir(at)paradise(dot)net(dot)nz>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Introducing an advanced Frequent Update Optimization
Date: 2006-11-07 02:00:53
Views: Raw Message | Whole Thread | Download mbox | Resend email
Lists: pgsql-hackers

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.

best wishes


In response to


Browse pgsql-hackers by date

  From Date Subject
Next Message JEAN-PIERRE PELLETIER 2006-11-07 02:10:40 Re: Index ignored with "is not distinct from", 8.2 beta2
Previous Message Jim C. Nasby 2006-11-07 01:16:33 Re: NULL in arrays