[ADMIN] query optimization - mysql vs postgresql

2006-05-18 Thread Warren Little
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

Re: [ADMIN] query optimization - mysql vs postgresql

2006-05-18 Thread Tomeh, Husam
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

Re: [ADMIN] query optimization - mysql vs postgresql

2006-05-18 Thread Warren Little
: [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