Re: cache table

From: Joseph Shraibman <jks(at)selectacast(dot)net>
To: "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com>
Subject: Re: cache table
Date: 2004-05-04 15:27:53
Message-ID: 4097B679.60301@selectacast.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

scott.marlowe wrote:

> I think you might be interested in materialized views. You could create
> this as a materialized view which should be very fast to just select *
> from.

That seems to be the count table I envisioned. It just hides the
details for me. It still has the problems of an extra UPDATE every time
the data table is updated and generating a lot of dead tuples.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Bruno Wolff III 2004-05-04 16:36:19 Re: Bug in optimizer
Previous Message scott.marlowe 2004-05-04 13:52:12 Re: cache table