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
