| 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
| 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 |
| 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 |