Sergey Konoplev <gray.ru@xxxxxxxxx> writes: > On Wed, Mar 27, 2013 at 9:56 AM, salah jubeh <s_jubeh@xxxxxxxxx> wrote: >> I have a database which is bloated because of vacuum full, so you find >> indexes bigger than the table itself. > Table can not be bloated because of vacuum full, it removes bloat from > the table and its indexes. Um, well, that depends a lot on which PG version the OP is running (which he didn't say). The pre-9.0 implementation of VACUUM FULL was notorious for creating index bloat, because it shuffled heap entries around to compact heap space, but created an additional index entry for each such heap-tuple motion. 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
