Re: Disappointing performance in db migrated from MS SQL Server

Please run your largest (worst) queries using EXPLAIN ANALYZE and send
in the results so we can see how the queries are being executed &
optimized.

On Feb 12, 2004, at 11:29 AM, Leon Out wrote:

> Hello all. I am in the midst of porting a large web application from a
> MS SQL Server backend to PostgreSQL. The migration work is basically
> complete, and we're at the testing and optimization phase of the
> project. The results so far have been disappointing, with Postgres
> performing queries in about the same time as SQL Server even though
> Postgres is running on a dedicated box with about 4 times the clock
> speed of the SQL Server box. For a chart of my results, please see
> http://leonout.com/pggraph.pdf for a graph of some test results.
>

--
PC Drew
Manager, Dominet

IBSN
1600 Broadway, Suite 400
Denver, CO 80202

Phone: 303-984-4727 x107
Cell: 720-841-4543
Fax: 303-984-4730
Email: drewpc(at)ibsncentral(dot)com