Andy Colson <andy@squeakycode.net> wrote:
> Wow, so out of 46 columns, half of them have indexes? That's a
> lot. I'd bet you could drop a bunch of them. You should review
> them and see if they are actually helping you. You already found
> out that maintain all those indexes is painful. If they are not
> speeding up your SELECT's by a huge amount, you should drop them.
You might want to review usage counts in pg_stat_user_indexes.
-Kevin