You're right, REINDEX was not done. I've stopped the VACUUM, did a proper server restart (pg_ctl -m fast -w restart) and will work on rebuilding relations. Seems like I have another issue with a bunch of bloated tables on my way also.
Thanks for the support. 2012/9/26 Andres Freund <and...@2ndquadrant.com>: >> Last entry from the 9.1.6 recommended VACUUM (FREEZE, VERBOSE, ANALYZE) > It recommended doing a REINDEX first though? I guess you didn't do that? > > ... > > I guess you cannot cancel the vacuum? Last time it was in a cycle without > checking interrupts inbetween. > > Can you restart the server? -- Victor Y. Yegorov -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
