Re: functional indexes instead of regular index on field(s)?

From: Bruno Wolff III <bruno(at)wolff(dot)to>
To: Tomaz Borstnar <tomaz(dot)borstnar(at)over(dot)net>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: functional indexes instead of regular index on field(s)?
Date: 2003-06-16 17:58:48
Message-ID: 20030616175848.GA3327@wolff.to
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Mon, Jun 16, 2003 at 19:38:19 +0200,
Tomaz Borstnar <tomaz(dot)borstnar(at)over(dot)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.

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Tomasz Myrta 2003-06-16 19:49:40 sequential scans on few columns tables
Previous Message Tomaz Borstnar 2003-06-16 17:38:19 functional indexes instead of regular index on field(s)?