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

>>>>> "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!