Re: Speeding up 'bulk' delete (and/or seeing what is going on while the delete is being processed)

Steve T <steve@retsol.co.uk> writes:
> PS Is there a reason that PostgreSql doesn't automatically create the
> foreign key indexes?

Sometimes you don't need/want them, or they might already exist because
of other constraints you made.  It is a bit of a gotcha for newbies,
but we've concluded that forcing such indexes to be made would be a
net loss.

            regards, tom lane