Skip site navigation (1) Skip section navigation (2)

Re: Help with optimizing query

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 (view raw or flat)
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







In response to

pgsql-general by date

Next:From: Ulrich WisserDate: 2004-08-20 11:20:49
Subject: Re: insert waiting
Previous:From: RazvanDate: 2004-08-20 11:12:04
Subject: Re: Postgres and JBOSS

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group