On Thu, Oct 1, 2009 at 3:10 PM, APseudoUtopia <apseudoutopia@xxxxxxxxx> wrote: > Hey list, > > After some downtime of my site while completing rigorous database > maintenance, I wanted to make sure all the databases were fully > vacuumed and analyzed. I do run autovacuum, but since I made several > significant changes, I wanted to force a vacuum before I brought my > site back online. > > Here's what happened: > > $ vacuumdb --all --full --analyze --no-password > vacuumdb: vacuuming database "postgres" > vacuumdb: vacuuming database "web_main" > vacuumdb: vacuuming of database "web_main" failed: ERROR: huge tuple > > I was told on IRC that this may be related to a GIN index. I do have > several GIN indexes used for full-text searching. I tried googling, > but nothing much came up. > > Thanks for the help. > Sorry, I failed to mention: PostgreSQL 8.4.0 on i386-portbld-freebsd7.2, compiled by GCC cc (GCC) 4.2.1 20070719 [FreeBSD], 32-bit -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
