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

Reply via email to