Re: Postgresql Materialized views

From: Andreas Pflug <pgadmin(at)pse-consulting(dot)de>
To: Simon Riggs <simon(at)2ndquadrant(dot)com>
Cc: Heikki Linnakangas <heikki(at)enterprisedb(dot)com>, Merlin Moncure <mmoncure(at)gmail(dot)com>, Jean-Michel Pouré <jm(at)poure(dot)com>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Postgresql Materialized views
Date: 2008-01-17 00:06:59
Message-ID: 478E9C23.1020206@pse-consulting.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Bruce Momjian 2008-01-17 02:58:11 Re: [HACKERS] SSL over Unix-domain sockets
Previous Message Andrew Dunstan 2008-01-16 23:27:15 Re: Renaming a constraint's index