> If not, dump and restore the table. Unfortunately we do not have adequate disk space, we wanted to reduce the database size in order to back it up, cause there is no more space for backups either 0_o Is there any way to prevent Dump & restore - you mean pg_dump? ---------------------------(end of broadcast)--------------------------- TIP 6: explain analyze is your friend