Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows
| От | Richard Broersma |
|---|---|
| Тема | Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows |
| Дата | |
| Msg-id | AANLkTi=NtZKJMz+zjf4Aoga0yEWCiPyFr72VYiEaG2R8@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows (Tom Polak <tom@rockfordarearealtors.org>) |
| Ответы |
Re: Compared MS SQL 2000 to Postgresql 9.0 on Windows
|
| Список | pgsql-performance |
On Fri, Dec 17, 2010 at 9:08 AM, Tom Polak <tom@rockfordarearealtors.org> wrote: > Any comparisons in terms of performance would be great. If not, how can I > quickly truly compare the two systems myself without coding everything to > work for both? Thoughts? Opinions? I can only offer anecdotal information. If you strictly have an OLTP workload, with lots of simultaneous connections issuing queries across small chunks of data, then PostgreSQL would be a good match for SQL server. On the other-hand, if some of your work load is OLAP with a few connections issuing complicated queries across large chunks of data, then PostgreSQL will not perform as well as SQL server. SQL server can divide processing load of complicated queries across several processor, while PostgreSQL cannot. So, I guess it depends upon your workload. -- Regards, Richard Broersma Jr.
В списке pgsql-performance по дате отправления: