From: | Andres Freund <andres(at)anarazel(dot)de> |
---|---|
To: | pgsql-performance(at)postgresql(dot)org |
Cc: | Tom Polak <tom(at)rockfordarearealtors(dot)org> |
Subject: | Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows |
Date: | 2010-12-07 18:20:36 |
Message-ID: | 201012071920.37146.andres@anarazel.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Ivan Voras | 2010-12-07 18:21:13 | Re: Performance under contention |
Previous Message | Andy Colson | 2010-12-07 18:13:56 | Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows |