Tiago Babo <tiago(dot)babo(at)gmail(dot)com> writes:
> I don't really understand how PostgreSQL handles indexes, but would it be
> possible that the INDEX is being used/updated at that moment and so the
> INSERT doesn't know it exists? Can concurrency also be a problem?
Data activity shouldn't matter. If you're dropping and recreating the
whole index, that could matter.
regards, tom lane