| From: | Gaetano Mendola <mendola(at)bigfoot(dot)com> |
|---|---|
| To: | Marek Lewczuk <newsy(at)lewczuk(dot)com> |
| Subject: | Re: Help with optimizing query |
| Date: | 2004-08-20 11:15:47 |
| Message-ID: | 4125DD63.9000107@bigfoot.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 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.
Where is the query ?
Also tables definition could help.
The first look suggest that the statistics are not up to date or you
have to increase your default_statistics_target.
337 rows vs 3618 rows
Regards
Gaetano Mendola
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ulrich Wisser | 2004-08-20 11:20:49 | Re: insert waiting |
| Previous Message | Razvan | 2004-08-20 11:12:04 | Re: Postgres and JBOSS |