Tiffany Thang <tiffanyth...@gmail.com> writes: > Can someone explain the use of creating multiple indexes on the same > column?
There is none, unless the indexes have different properties (e.g. different opclasses and/or index AMs). I'd suggest reading https://www.postgresql.org/docs/current/indexes.html regards, tom lane
