pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed
From: Mezei Zoltán <mezei.zoltan@telefor.hu>
To: Richard Huxton <dev@archonet.com>
Cc: pgsql-performance@postgresql.org
Subject: Re: Deceiding which index to use
Date: Fri, 09 Mar 2007 17:07:05 +0100
Message-ID: <45F18629.4000808@telefor.hu> (raw)
In-Reply-To: <45F182B7.30507@archonet.com>
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>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
<small>Richard Huxton wrote:</small>
<blockquote cite="mid:45F182B7.30507@archonet.com" type="cite">
  <meta http-equiv="Content-Type" content="text/html; ">
  <meta name="Generator" content="MS Exchange Server version 6.5.7226.0">
  <title>Re: [PERFORM] Deceiding which index to use</title>
<!-- Converted from text/plain format -->
  <p><font size="2">There is a cost to increasing the stats values,
otherwise it'd already<br>
be set at 1000. In your case I'm not sure if 100-200 vs 8-9 messages is<br>
enough to skew things. Only one way to find out...<br>
  </font></p>
</blockquote>
<small>Well, I tried. The situation is:<br>
<br>
- when I look for a subscriber which the planner thinks to have more
messages --&gt; it uses the index on crd<br>
- when I look for a subscriber which the planner thinks to have less
messages --&gt; it uses the index on subscriber_id<br>
<br>
I think that's OK, even if it still don't do what I really would like
to see it do :-)<br>
<br>
Thanks for all your help, maybe I know a little bit more about
poostgresql than before.<br>
<br>
Zizi</small><br>
</body>
</html>



view thread (13+ messages)  latest in thread

Message-ID: <45F18629.4000808@telefor.hu>
Permalink:  ../45F18629.4000808@telefor.hu/
Also on:    postgresql.org/message-id/45F18629.4000808@telefor.hu

 · 

reply
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: mezei.zoltan@telefor.hu, dev@archonet.com
  Subject: Re: Deceiding which index to use
  In-Reply-To: <45F18629.4000808@telefor.hu>

* 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