>>>>> "TL" == Tom Lane <tgl@sss.pgh.pa.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!