Re: [PERFORM] Index not being used on composite type for particular query

2017-05-20 Thread Zac Goldstein
Thanks for the fast reply and explanation, Tom. Overall, I have been pleasantly surprised with the leniency of indexes on range types. On Sat, May 20, 2017 at 5:00 PM, Tom Lane wrote: > Zac Goldstein writes: > > This uses the index: > > ... > > But this doesn't:

[PERFORM] Index not being used on composite type for particular query

2017-05-20 Thread Zac Goldstein
Hello, The index on my composite type seems to be working most of the time, but there's a query I need to run where it's not working even with enable_seqscan=false. The composite type uses int and numrange subcolumns, and is designed to operate primarily as a range type. It will probably be easi