Postgres Pro
Downloads
Home   >   mailing lists

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

From Tomaz Borstnar
Subject functional indexes instead of regular index on field(s)?
Date
Msg-id 5.2.1.1.0.20030616193558.02a5f0c0@127.0.0.1
Whole thread Raw
Responses Re: functional indexes instead of regular index on field(s)?  (Bruno Wolff III <bruno@wolff.to>)
List pgsql-performance
Tree view 
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.

pgsql-performance by date:

Previous
From: Josh Berkus
Date:
Subject: Re: A bit OT- RE: Re-ordering .CONF params ... questions for this list
Next
From: Bruno Wolff III
Date:
Subject: Re: functional indexes instead of regular index on field(s)?