Re: [ADMIN] Q: Structured index - which one runs faster?

>>>>> "TL" == Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:

>> In particular, is user_list_owner_id redundant to
>> user_list_oid_created?

TL> Any of the three indexes can be used for a search on owner_id alone, so
TL> yeah, user_list_owner_id is redundant. It would be marginally faster to
TL> use user_list_owner_id for such a search, just because it's physically
TL> smaller than the other two indexes, but against that you have to balance
TL> the extra update cost of maintaining the additional index.

This is great info. That extra index is gonna be nuked in about 37.23
seconds... It takes up a lot of space and is wasting time with
updates and inserts, which happen a *lot* on that table (nearly 10
million rows).

Thanks!