Skip site navigation (1) Skip section navigation (2)

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: (view raw, whole thread or download thread mbox)
Lists: pgsql-generalpgsql-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

In response to

pgsql-hackers by date

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

pgsql-general by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group