Hi, On 2019-04-12 09:51:51 -0400, Tom Lane wrote: > 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).
Well, it can be beneficial to create a new index concurrently, and then drop the old one concurrently. Before v12 that's the only way to recreate an index during production, if it e.g. bloated. Greetings, Andres Freund
