Pailloncy Jean-Gerard <[EMAIL PROTECTED]> writes: > Update to my case: > I drop and recreate the index and there was no problem this time. > Strange...
Well, that time there wasn't actually any work for VACUUM FULL to do. I think the bloat is probably driven by having to move a lot of rows in order to shrink the table. That means creating and deleting a lot of index entries. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings