X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.130]) by svr1.postgresql.org (Postfix) with ESMTP id 7C16BD1B58E for ; Sun, 12 Oct 2003 19:40:47 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (neptune.hub.org [64.117.224.130]) (amavisd-new, port 10024) with ESMTP id 32587-05 for ; Sun, 12 Oct 2003 16:40:16 -0300 (ADT) Received: from fuji.krosing.net (217-159-136-226-dsl.kt.estpak.ee [217.159.136.226]) by svr1.postgresql.org (Postfix) with ESMTP id 2D761D1B554 for ; Sun, 12 Oct 2003 16:39:13 -0300 (ADT) Received: from fuji.krosing.net (localhost.localdomain [127.0.0.1]) by fuji.krosing.net (8.12.8/8.12.8) with ESMTP id h9CJdQuH015952; Sun, 12 Oct 2003 22:39:27 +0300 Received: (from hannu@localhost) by fuji.krosing.net (8.12.8/8.12.8/Submit) id h9CJdPgW015950; Sun, 12 Oct 2003 22:39:25 +0300 X-Authentication-Warning: fuji.krosing.net: hannu set sender to hannu@tm.ee using -f Subject: Re: Index/Foreign Key Question From: Hannu Krosing To: Andrew Sullivan Cc: PgSQL Performance ML 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> Content-Type: text/plain Content-Transfer-Encoding: 7bit Message-Id: <1065987564.15342.2.camel@fuji.krosing.net> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.4.5 Date: Sun, 12 Oct 2003 22:39:25 +0300 X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200310/400 X-Sequence-Number: 4148 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