Re: Postgresql Materialized views - Mailing list pgsql-hackers

From Andreas Pflug
Subject Re: Postgresql Materialized views
Date
Msg-id 478E9C23.1020206@pse-consulting.de
Whole thread Raw
In response to Re: Postgresql Materialized views  (Simon Riggs <simon@2ndquadrant.com>)
List pgsql-hackers
Simon Riggs wrote:
>
> My thinking was if you load a 1000 rows and they all have the same key
> in your summary table then you'll be doing 1000 updates on a single row.
>   
This is true because the statement level triggers are still rudimentary, 
with no OLD and NEW support. A single AFTER statement trigger execution 
could maintain the summary table with much less effort.

Regards,
Andreas



pgsql-hackers by date:

Previous
From: Andrew Dunstan
Date:
Subject: Re: Renaming a constraint's index
Next
From: "Marc G. Fournier"
Date:
Subject: Re: postgresql in FreeBSD jails: proposal