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

• Slow count(*) at 2008-01-02 15:29:24 from Abraham, Danny

pgsql-hackers by date

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

pgsql-general by date

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