Re: Best practice to get performance

From: John R Pierce <pierce(at)hogranch(dot)com>
To: Fredric Fredricson <Fredric(dot)Fredricson(at)bonetmail(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Best practice to get performance
Date: 2010-11-18 23:09:56
Message-ID: 4CE5B244.7030709@hogranch.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 11/18/10 2:56 PM, Fredric Fredricson wrote:
>
> What puzzle me though is that this use is never mentioned in the
> discussions, at least as far as I can see. Am I doing something
> "strange"? Is this something you should not have to do if you have
> "proper" database design?

in certain other enterprise oriented databases, there is a feature known
as Materialized Views, which provides functionality similar to what
you're doing.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Mage 2010-11-19 01:36:39 subquery join order by
Previous Message Fredric Fredricson 2010-11-18 22:56:12 Best practice to get performance