From: Richard Huxton <dev@archonet.com>
To: Mezei Zoltán <mezei.zoltan@telefor.hu>
Cc: pgsql-performance@postgresql.org
Subject: Re: Deceiding which index to use
Date: Fri, 09 Mar 2007 16:18:57 +0000
Message-ID: <45F188F1.4010905@archonet.com> (raw)
In-Reply-To: <45F18629.4000808@telefor.hu>
References: <45F15F0F.8080403@telefor.hu>
<45F1715E.1050000@archonet.com>
<45F174CF.8010302@telefor.hu>
<45F1775A.8030701@archonet.com>
<45F179AB.7040000@telefor.hu>
<45F17B70.60001@archonet.com>
<45F180D2.5080201@telefor.hu>
<45F182B7.30507@archonet.com>
<45F18629.4000808@telefor.hu>
Mezei Zoltán wrote:
> Richard Huxton wrote:
>>
>> There is a cost to increasing the stats values, otherwise it'd
>> already be set at 1000. In your case I'm not sure if 100-200 vs 8-9
>> messages is enough to skew things. Only one way to find out...
>>
> Well, I tried. The situation is:
>
> - when I look for a subscriber which the planner thinks to have more
> messages --> it uses the index on crd - when I look for a subscriber
> which the planner thinks to have less messages --> it uses the index
> on subscriber_id
>
> I think that's OK, even if it still don't do what I really would like
> to see it do :-)
Well, it's decision about where the costs cross over will be in the
other "cost" settings in postgresql.conf. The thing is, it's not worth
tuning for just this one query, because you can easily end up running
everything else more slowly.
> Thanks for all your help, maybe I know a little bit more about
> poostgresql than before.
--
Richard Huxton
Archonet Ltd
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: dev@archonet.com, mezei.zoltan@telefor.hu
Subject: Re: Deceiding which index to use
In-Reply-To: <45F188F1.4010905@archonet.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