Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows

Поиск
Список
Период
Сортировка
От Andres Freund
Тема Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows
Дата
Msg-id 201012071920.37146.andres@anarazel.de
обсуждение исходный текст
Ответ на Compared MS SQL 2000 to Postgresql 9.0 on Windows  (Tom Polak <tom@rockfordarearealtors.org>)
Список 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

В списке pgsql-performance по дате отправления:

Предыдущее
От: Andy Colson
Дата:
Сообщение: Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows
Следующее
От: Ivan Voras
Дата:
Сообщение: Re: Performance under contention