Postgres Pro
Downloads
Home   >   mailing lists

Re: Unacceptable postgres performance vs. Microsoft sqlserver - Mailing list pgsql-general

From Andreas 'ads' Scherbaum
Subject Re: Unacceptable postgres performance vs. Microsoft sqlserver
Date
Msg-id 20080414220424.78d4ff0b@iridium.wars-nicht.de
Whole thread Raw
In response to Re: Unacceptable postgres performance vs. Microsoft sqlserver  (Chris Browne <cbbrowne@acm.org>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: Verifying SSL Certificate on the Client Side
Next
From: Gregory Stark
Date:
Subject: Re: Unacceptable postgres performance vs. Microsoft sqlserver