pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
functional 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>
  2003-06-16 17:58 ` Re: functional indexes instead of regular index on field(s)? Bruno Wolff III <bruno@wolff.to>
  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: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>
  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