John Melesky <john.melesky@xxxxxxxxxxxxxxx> writes: > It seems clear that there were dead tuples, since the table size shrank to > an eighth of its previous size. Why did analyze not pick that up? Dead tuples and empty space are not the same thing. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general