The biggest improvement we noticed was in two areas. We have some very
complex selects that join 7-8 tables which perform 30-40% faster under
PGSQL. The second thing that performs better are the above mentioned
result set returning stored procedures.
BTW, the reason we started looking at PSQL is not due to performance,
this just came as a pleasant surprise. The real reason is in the fact
the we are 90% linux in our server environment and the only Windows
component is SQL Server 7. SS7 does not play nicely with Linux and
lacks any tools to use from the Linux environment. Windows itself is
hard to manage remotely and since the production environment is
co-located it became a real issue.
Avi
On Wednesday, Jun 11, 2003, at 22:24 America/Chicago, Maksim Likharev
wrote:
> My I ask on what operations PG better than MSSQL?
>
> cause out of my observations only spatial data types,
> could influence a choice between MSSQL and PG.
>
> Thank you.