Tiffany Thang <tiffanythang(at)gmail(dot)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://stream.boxwatch.ru/docs/current/indexes.html
regards, tom lane