Warren Little wrote:
> Sorry,
> here are the attachments.
> Not sure about the statistics question, I have done a vacuum analyze on
> every table in the database.
The problem is that the planner is unable to appropiately order OUTER
JOINs in released versions. In 8.2 it can do some reordering, so
Subject: [ADMIN] query optimization - mysql vs postgresql
Hello,
my team is in the process of migrating some data from a mysql (5.0) database to our core postgres (8.1.3) database.
We are running into some performance issues with the postgres versions of the queries.
MySQL takes
, May 18, 2006 9:06 AMTo:
pgsql-admin@postgresql.orgSubject: [ADMIN] query optimization - mysql
vs postgresql
Hello,my team is in the process of migrating some data from a
mysql (5.0) database to our core postgres (8.1.3) database.We are running
into some performance issues with the postgres
Hello,
my team is in the process of migrating some data from a mysql (5.0) database to our core postgres (8.1.3) database.
We are running into some performance issues with the postgres versions of the queries.
MySQL takes about 150ms to run the query where postgres is taking 2500ms.
The servers
