a MySQL to PostgreSQL successful port, but performance is bad... - Mailing list pgsql-novice

From Jim Brown
Subject a MySQL to PostgreSQL successful port, but performance is bad...
Date
Msg-id 20060527203823.43589.qmail@web54207.mail.yahoo.com
Whole thread Raw
Responses Re: a MySQL to PostgreSQL successful port, but performance is bad...
Re: a MySQL to PostgreSQL successful port, but performance is bad...
List pgsql-novice
I just converted a working app from MySQL to
PostgreSQL. I used fabForce's DBDesigner 4 to build
and maintain my data model in MySQL. To port the
schema, I exported the data model to an SQL file, and
hand tweaked the file to change datatypes and move
INDEX statements out of the Create Table statements.
Everything worked like a charm. I can switch back and
forth between the two databases by simply changing the
ODBC connect string.

Here's my problem, though: queries in mySQL are almost
instantaneous, whereas those same queries in
PostgreSQL can take four seconds or more - even when
I'm hitting a table with only one row. I'll bet I have
something misconfigured, but I'm a newbie FNG, and I
don't yet know my way around yet.

BTW, I did a search on mySQL in the novice threads,
and performance seems like a hot-button issue. Please
be assured that I have no issues or agendas with
either product, and fully assume that I have something
misconfigured. I'm slightly overwhelmed by the volume
of documentation (on-line, and I bought books by
Douglas&Douglas and Matthew&Stone) and would like a
few points in the correct direction.

Help is absolutely appreciated.

Regards,
Jim Brown

PostgreSQL 8.1.3
PostgreSQL ANSI ODBC driver 8.01.02.00
PSQLODBCA.DLL 1/31/2006


__________________________________________________
Do You Yahoo!?
Tired of spam?  Yahoo! Mail has the best spam protection around
http://mail.yahoo.com

pgsql-novice by date:

Previous
From: "Shreehari S"
Date:
Subject: Urgent Help
Next
From: Donald Brady
Date:
Subject: trigger help