pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Hannu Krosing <hannu@tm.ee>
To: Andrew Sullivan <andrew@libertyrms.info>
Cc: PgSQL Performance ML <pgsql-performance@postgresql.org>
Subject: Re: Index/Foreign Key Question
Date: Sun, 12 Oct 2003 22:39:25 +0300
Message-ID: <1065987564.15342.2.camel@fuji.krosing.net> (raw)
In-Reply-To: <20031012192827.GC20538@libertyrms.info>
References: <006a01c38f72$25461720$1100000a@busbydev>
	<1065821515.16433.10.camel@haggis>
	<009c01c38f76$02150230$1100000a@busbydev>
	<1065837672.16433.23.camel@haggis>
	<20031012192827.GC20538@libertyrms.info>

Andrew Sullivan kirjutas P, 12.10.2003 kell 22:28:
> On Fri, Oct 10, 2003 at 09:01:12PM -0500, Ron Johnson wrote:
> > 
> > > Does PostgreSQL only pick one index per table on the select statements?
> > 
> > That's it's preference.
> 
> As far as I know, that's all it can do.  Do you know something
> different?

Tom has mentioned the possibility of using bitmaps as a an intermadiate
step, this would make star joins much faster as we could AND all index
info and actually examine onlu tuples that mach all indexes.

None of it is done by now, AFAIK.

-------
Hannu




view thread (7+ messages)

Message-ID: <1065987564.15342.2.camel@fuji.krosing.net>
Permalink:  ../1065987564.15342.2.camel@fuji.krosing.net/
Also on:    postgresql.org/message-id/1065987564.15342.2.camel@fuji.krosing.net

 · 

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 from your mail client; the link fills in
  the headers below: reply via email
  Some clients, webmail especially, drop In-Reply-To and References from
  a link, and the reply then starts a new thread: use the mbox below.

  To: pgsql-performance@postgresql.org
  Cc: hannu@tm.ee, andrew@libertyrms.info
  Subject: Re: Index/Foreign Key Question
  In-Reply-To: <1065987564.15342.2.camel@fuji.krosing.net>
  References: <006a01c38f72$25461720$1100000a@busbydev> <1065821515.16433.10.camel@haggis> <009c01c38f76$02150230$1100000a@busbydev> <1065837672.16433.23.camel@haggis> <20031012192827.GC20538@libertyrms.info> <1065987564.15342.2.camel@fuji.krosing.net>

* 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