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
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 versions
: [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