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