On Tue, Feb 14, 2012 at 6:27 AM, Albe Laurenz wrote:
> A materialized view is actually a table that holds a (possibly
> aggregated)
> copy of data from elsewhere in the database.
>
> Apart from materialized views, you can denormalize for performance by
> adding columns to tables that store a copy
JG wrote:
> To specify further, the question is, can I count on PostgreSQL to
denormalize the database when it
> would be better for the performance, or should I always denormalize
the database and all the querys
> myself.
PostgreSQL does not do such things automatically. You'll have to do so
your
On Mon, Feb 13, 2012 at 15:48, JG wrote:
> I would like to ask weather PostgreSQL does database denormalization at
> runtime.
>
> To specify further, the question is, can I count on PostgreSQL to denormalize
> the database when it would be better for the performance, or should I always
> denorm
Hi
I would like to ask weather PostgreSQL does database denormalization at runtime.
That is, for example, if I have a normalized database and I use lots of querys
that would run faster on a denormalized database, than will PostgreSQL create a
denormalized version of the database for internal u
