From: John Arbash Meinel <john@arbash-meinel.com>
To: Sebastian Hennebrueder <usenet@laliluna.de>
Cc: pgsql-performance@postgresql.org
Subject: Re: Optimize complex join to use where condition before
Date: Fri, 13 May 2005 17:15:25 -0500
Message-ID: <428526FD.7010208@arbash-meinel.com> (raw)
In-Reply-To: <42852509.6060206@laliluna.de>
References: <4283D985.4080908@laliluna.de>
<428414DE.8030904@laliluna.de>
<42852509.6060206@laliluna.de>
Sebastian Hennebrueder wrote:
> I found a solution to improve my query. I do not know why but the
> statistics for all column has been 0.
> I changed this to 10 for index columns and to 20 for all foreign key
> columns.
> and to 100 for foreign key columns.
> I set the random page cost to 2
> and now the query runs as expected.
>
> Many thanks to all of the posts in my and in other threads which
> helped a lot.
>
> Sebastian
I think 0 = use default. But still, changing to 20 and 100 probably
fixes your problems.
John
=:->
Attachments:
signature.asc (application/pgp-signature, 252B) download
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: john@arbash-meinel.com, usenet@laliluna.de
Subject: Re: Optimize complex join to use where condition before
In-Reply-To: <428526FD.7010208@arbash-meinel.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox