pg.ddx.io pgsql-performance@postgresql.org mailing list archive
help / color / mirror / Atom feedfunctional indexes instead of regular index on field(s)?
2+ messages / 2 participants
[nested] [flat]
* functional indexes instead of regular index on field(s)?
@ 2003-06-16 17:38 Tomaz Borstnar <tomaz.borstnar@over.net>
0 siblings, 1 reply; 2+ messages in thread
From: Tomaz Borstnar @ 2003-06-16 17:38 UTC (permalink / raw)
To: 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.
^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: functional indexes instead of regular index on field(s)?
@ 2003-06-16 17:58 Bruno Wolff III <bruno@wolff.to>
parent: Tomaz Borstnar <tomaz.borstnar@over.net>
0 siblings, 0 replies; 2+ messages in thread
From: Bruno Wolff III @ 2003-06-16 17:58 UTC (permalink / raw)
To: Tomaz Borstnar <tomaz.borstnar@over.net>; +Cc: pgsql-performance
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.
^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2003-06-16 17:58 UTC | newest]
Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2003-06-16 17:38 functional indexes instead of regular index on field(s)? Tomaz Borstnar <tomaz.borstnar@over.net>
2003-06-16 17:58 ` Bruno Wolff III <bruno@wolff.to>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox