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.
---------------------------(end of broadcast)--------------------------- TIP 6: Have you searched our list archives?
http://archives.postgresql.org