Marek Lewczuk wrote:
> 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
In response to
pgsql-general by date
|Next:||From: Ulrich Wisser||Date: 2004-08-20 11:20:49|
|Subject: Re: insert waiting|
|Previous:||From: Razvan||Date: 2004-08-20 11:12:04|
|Subject: Re: Postgres and JBOSS|