If you supply the following:
1. The schema (including available indexes) for each table in the query
2. The actual query
3. The row counts for the tables via select count(*)
I suspect that someone can formulate a query that is as fast as you
need.
> -----Original Message-----
> From: pgsql-general-owner@postgresql.org
> [mailto:pgsql-general-owner@postgresql.org] 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 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.
>
> ML
>