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 maybe you will point me what shall I do. In the attachment I send you
the result of "explain analyze".
I will be appreciated for any help. Thanks in advance.
pgsql-general by date
|Next:||From: Karsten Hilbert||Date: 2004-08-20 09:04:30|
|Subject: Re: How to setup default value "0000-00-00" for "date"|
|Previous:||From: Michal Hlavac||Date: 2004-08-20 08:55:53|
|Subject: 7.4.5 release|