Re: cache table - Mailing list pgsql-performance

From Joseph Shraibman
Subject Re: cache table
Date
Msg-id 4097B679.60301@selectacast.net
Whole thread Raw
In response to Re: cache table  ("scott.marlowe" <scott.marlowe@ihs.com>)
Responses Re: cache table
List 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.

pgsql-performance by date:

Previous
From: "scott.marlowe"
Date:
Subject: Re: cache table
Next
From: Bruno Wolff III
Date:
Subject: Re: Bug in optimizer