On Fri, Dec 17, 2010 at 9:08 AM, Tom Polak <t...@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. -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
