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) |
Список | pgsql-performance |
Дерево обсуждения
Compared MS SQL 2000 to Postgresql 9.0 on Windows
(Tom Polak,
)
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows ("Kevin Grittner", )
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows (Andy Colson, )
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows (Andres Freund, )
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows (Craig James, )
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows (Andy Colson, )
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows (Richard Broersma, )
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows (Kenneth Marshall, )
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows (Andy Colson, )
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows (Tom Polak, )
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows (Craig James, )
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows (Gary Doades, )
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows ("Kevin Grittner", )
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows ("Pierre C", )
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows (Tom Polak, )
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows (Craig James, )
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows (Scott Marlowe, )
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows (Gael Le Mignot, )
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows (Scott Marlowe, )
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows ("Pierre C", )
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows (Richard Broersma, )
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows (Justin Pitts, )
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows (Rob Wultsch, )
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows (Robert Haas, )
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows (Andy Colson, )
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows (Tom Polak, )
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows (Robert Haas, )
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows (Andy Colson, )
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows (Gary Doades, )
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows (Mladen Gogala, )
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows ("Kevin Grittner", )
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows (Andy Colson, )
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows (Andres Freund, )
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows (Craig James, )
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows (Andy Colson, )
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows (Richard Broersma, )
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows (Kenneth Marshall, )
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows (Andy Colson, )
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows (Tom Polak, )
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows (Craig James, )
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows (Gary Doades, )
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows ("Kevin Grittner", )
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows ("Pierre C", )
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows (Tom Polak, )
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows (Craig James, )
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows (Scott Marlowe, )
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows (Gael Le Mignot, )
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows (Scott Marlowe, )
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows ("Pierre C", )
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows (Richard Broersma, )
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows (Justin Pitts, )
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows (Rob Wultsch, )
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows (Robert Haas, )
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows (Andy Colson, )
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows (Tom Polak, )
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows (Robert Haas, )
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows (Andy Colson, )
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows (Gary Doades, )
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows (Mladen Gogala, )
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 по дате отправления: