Re: Slow count(*)

From: Simon Riggs <simon(at)2ndquadrant(dot)com>
To: "Abraham, Danny" <danny_abraham(at)bmc(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Slow count(*)
Date: 2008-01-02 18:12:47
Message-ID: 1199297567.7260.161.camel@ebony.site
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general pgsql-hackers

On Wed, 2008-01-02 at 09:29 -0600, Abraham, Danny wrote:

> Our product is about 20 times slower on Postgres compared to MS SQL
> Server.

If you want to have a cross-platform product then you must consider how
to access multiple systems both accurately and quickly. Not much point
catering for the different SQL dialects and then ignoring the
performance differences. All products are not the same; you will find
many advantages with Postgres.

--
Simon Riggs
2ndQuadrant http://www.2ndQuadrant.com

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Simon Riggs 2008-01-02 18:16:13 Re: Table rewrites vs. pending AFTER triggers
Previous Message Simon Riggs 2008-01-02 17:56:14 Dynamic Partitioning using Segment Visibility Maps

Browse pgsql-general by date

  From Date Subject
Next Message Fernando Hevia 2008-01-02 18:43:42 PG is in different timezone than the OS
Previous Message Tom Lane 2008-01-02 18:00:32 Re: visibility rules for AFTER UPDATE Constraint Triggers Function