Re: Slow count(*) - Mailing list pgsql-hackers

From Simon Riggs
Subject Re: Slow count(*)
Date
Msg-id 1199297567.7260.161.camel@ebony.site
Whole thread Raw
In response to Slow count(*)  ("Abraham, Danny" <danny_abraham@bmc.com>)
List 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



pgsql-hackers by date:

Previous
From: Simon Riggs
Date:
Subject: Dynamic Partitioning using Segment Visibility Maps
Next
From: Simon Riggs
Date:
Subject: Re: Table rewrites vs. pending AFTER triggers