PG Bug reporting form <noreply(at)postgresql(dot)org> writes:
> The steps performed are as below:
> - Renamed the original table as _bkp
> - Dropped indexes and constraints on the backup table
> - Created the original table along with indexes with the same index name as
> before
> Post performing this activity, the queries which where performing well
> before are running very slow.
Perhaps ANALYZE'ing the new table would help. I'd have expected
autovacuum to do that for you by now, but maybe it's not able to
complete for some reason.
regards, tom lane