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.