Re: cache table

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.