Tomas Szepe <[EMAIL PROTECTED]> writes:
> Trying to run "vacuum full analyze" on a ~200MB UTF8 database fails with:
> fs=> vacuum full analyze;
> WARNING: skipping "pg_authid" --- only table or database owner can vacuum it
> WARNING: skipping "pg_database" --- only table or database owner can vacuum
> it
> WARNING: skipping "pg_shdepend" --- only table or database owner can vacuum
> it
> WARNING: skipping "pg_shdescription" --- only table or database owner can
> vacuum it
> WARNING: skipping "pg_auth_members" --- only table or database owner can
> vacuum it
> ERROR: invalid memory alloc request size 4294965504
Hmm, please see if you can get a stack trace from that (set the
breakpoint at errfinish()). You might want to use vacuum verbose
first so that you can figure out which individual table is causing it.
regards, tom lane
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
