X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [64.117.224.193]) by svr1.postgresql.org (Postfix) with ESMTP id 616F830E358 for ; Mon, 16 Jun 2003 17:56:03 +0000 (GMT) Received: from svr1.postgresql.org ([64.117.224.193]) by localhost (svr1.postgresql.org [64.117.224.193]) (amavisd-new, port 10024) with ESMTP id 68674-04 for ; Mon, 16 Jun 2003 14:55:53 -0300 (ADT) Received: from wolff.to (wolff.to [66.93.249.74]) by svr1.postgresql.org (Postfix) with SMTP id 71E5B30EE02 for ; Mon, 16 Jun 2003 14:55:52 -0300 (ADT) Received: (qmail 3338 invoked by uid 500); 16 Jun 2003 17:58:48 -0000 Date: Mon, 16 Jun 2003 12:58:48 -0500 From: Bruno Wolff III To: Tomaz Borstnar Cc: pgsql-performance@postgresql.org Subject: Re: functional indexes instead of regular index on field(s)? Message-ID: <20030616175848.GA3327@wolff.to> Mail-Followup-To: Tomaz Borstnar , pgsql-performance@postgresql.org References: <5.2.1.1.0.20030616193558.02a5f0c0@127.0.0.1> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii Content-Disposition: inline In-Reply-To: <5.2.1.1.0.20030616193558.02a5f0c0@127.0.0.1> User-Agent: Mutt/1.5.4i X-Archive-Number: 200306/94 X-Sequence-Number: 2178 On Mon, Jun 16, 2003 at 19:38:19 +0200, Tomaz Borstnar wrote: > Hello! > > How much does planner take into consideration index size? Can one > help planner use indexes by having several functional indexes which should > be smaller instead of one bigger index which covers whole range of values > per field(s)? This sounds more like partial indexes than functional indexes.