Re: 0ut of Memory Error during Vacuum Analyze

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



"Tomeh, Husam" <htomeh@xxxxxxxxxxx> 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


[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux