On Mon, 14 Apr 2008 13:34:36 -0400 Chris Browne wrote: > If the entire purpose of your application is to run COUNT(*) against > the entireties of a table with 180M rows, then PostgreSQL may not be > the right database for your application.
For running a COUNT(*) without WHERE you could even add a trigger and a second table which contains statistics. With this simple workaround you have the answer for the COUNT(*) question in almost no time. Getting results for a COUNT(*) with WHERE is more complicated. Kind regards -- Andreas 'ads' Scherbaum German PostgreSQL User Group -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general