Postgres Pro
Downloads
Home   >   mailing lists

Re: functional indexes instead of regular index on field(s)? - Mailing list pgsql-performance

From Bruno Wolff III
Subject Re: functional indexes instead of regular index on field(s)?
Date
Msg-id 20030616175848.GA3327@wolff.to
Whole thread Raw
In response to functional indexes instead of regular index on field(s)?  (Tomaz Borstnar <tomaz.borstnar@over.net>)
List pgsql-performance
Tree view 
On Mon, Jun 16, 2003 at 19:38:19 +0200,
  Tomaz Borstnar <tomaz.borstnar@over.net> 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.

pgsql-performance by date:

Previous
From: Tomaz Borstnar
Date:
Subject: functional indexes instead of regular index on field(s)?
Next
From: Tomasz Myrta
Date:
Subject: sequential scans on few columns tables