Dennis Gearon wrote:
Is there any architectural way to speed it up? I'd actually like to run it every 2-60 seconds to update a counter on a page for the marketing guy, (which for once, is me :-
Could always maintain it with triggers. See http://wiki.postgresql.org/wiki/Slow_Counting for a discussion of this whole issue, with pointers to articles about alternate solutions.
-- Greg Smith, 2ndQuadrant US greg@xxxxxxxxxxxxxxx Baltimore, MD PostgreSQL Training, Services and Support www.2ndQuadrant.us Author, "PostgreSQL 9.0 High Performance" Pre-ordering at: https://www.packtpub.com/postgresql-9-0-high-performance/book -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
