From: Andres Freund <andres@anarazel.de>
To: pgsql-performance@postgresql.org
Cc: Tom Polak <tom@rockfordarearealtors.org>
Subject: Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows
Date: Tue, 7 Dec 2010 19:20:36 +0100
Message-ID: <201012071920.37146.andres@anarazel.de> (raw)
In-Reply-To: <378e24d1e3af88a49fbbb7c4d26f441a@mail.gmail.com>
References: <378e24d1e3af88a49fbbb7c4d26f441a@mail.gmail.com>
On Tuesday 07 December 2010 18:34:25 Tom Polak wrote:
> Then I did the same test via Postgresql and it took 8.85 seconds! I tried
> it again as I thought I did something wrong. I did a few tweaks such as
> increasing the shared buffers. Still the best I could get it to was 7.5
> seconds. This is insanely slow compared to MSSQL 2000. What am I missing.
> Here is my SQL statement for postgresql:
> select name,address,city,state,statename,stateid,other from pgtemp1 left
> join pgtemp2 on state=stateid
I think you would at least provide the exact schema and possibly some example
data (pg_dump) to get us somewhere.
I would suggest you post the output of EXPLAIN ANALYZE $yourquery - that gives
us information about how that query was executed.
Greetings,
Andres
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: andres@anarazel.de, tom@rockfordarearealtors.org
Subject: Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows
In-Reply-To: <201012071920.37146.andres@anarazel.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox