Re: [GENERAL] Help with optimizing query

2004-08-20 Thread Dann Corbit
[EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Marek Lewczuk > Sent: Friday, August 20, 2004 2:01 AM > To: Lista dyskusyjna pgsql-general > Subject: [GENERAL] Help with optimizing query > > > Hello, > I have a query, which is quite big and there is a huge differ

Re: [GENERAL] Help with optimizing query

2004-08-20 Thread Gaetano Mendola
Marek Lewczuk wrote: Hello, I have a query, which is quite big and there is a huge difference between execution time in MySQL and PostgreSQL. I think that I have made all possible steps to increase the speed of the query, but unfortunately it is still about 100 times slower. I'm out of ideas wh

[GENERAL] Help with optimizing query

2004-08-20 Thread Marek Lewczuk
Hello, I have a query, which is quite big and there is a huge difference between execution time in MySQL and PostgreSQL. I think that I have made all possible steps to increase the speed of the query, but unfortunately it is still about 100 times slower. I'm out of ideas what to do next, so ma