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

From: Tomaz Borstnar <tomaz(dot)borstnar(at)over(dot)net>
To: pgsql-performance(at)postgresql(dot)org
Subject: functional indexes instead of regular index on field(s)?
Date: 2003-06-16 17:38:19
Message-ID: 5.2.1.1.0.20030616193558.02a5f0c0@127.0.0.1
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

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)?

Thanks in advance.

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Bruno Wolff III 2003-06-16 17:58:48 Re: functional indexes instead of regular index on field(s)?
Previous Message Josh Berkus 2003-06-16 16:28:07 Re: A bit OT- RE: [PERFORM] Re-ordering .CONF params ... questions for this list