Vincent Janelle <random(at)goblinstudios(dot)com> writes:
> when entries are deleted from an table they're not deleted from the
> index, and vacuum doesn't clean them up.
This is entirely false.
There is a problem with recovering space in an index if the range of
indexed values changes over time. But claiming that we don't delete
index entries is just plain wrong.
regards, tom lane