Re: 0ut of Memory Error during Vacuum Analyze - Mailing list pgsql-performance

From Tom Lane
Subject Re: 0ut of Memory Error during Vacuum Analyze
Date
Msg-id 19986.1139939447@sss.pgh.pa.us
Whole thread Raw
In response to 0ut of Memory Error during Vacuum Analyze  ("Tomeh, Husam" <htomeh@firstam.com>)
List pgsql-performance
"Tomeh, Husam" <htomeh@firstam.com> writes:
> =# vacuum analyze code;
> ERROR:  out of memory
> DETAIL:  Failed on request of size 1073741820.

That looks a whole lot like a corrupt-data issue.  The apparent
dependency on maintenance_work_mem is probably illusory --- I suspect
some of your trials are selecting the corrupted row to use in the
ANALYZE stats, and others are randomly selecting other rows.

If you are able to pg_dump the table in question then this theory is
wrong, but I'd suggest trying that first.

            regards, tom lane

pgsql-performance by date:

Previous
From: Scott Marlowe
Date:
Subject: Re: out of memory
Next
From: Tom Lane
Date:
Subject: Re: Postgres slower than MS ACCESS