Re: Vacuum - Out of memory - Mailing list pgsql-admin

From Tom Lane
Subject Re: Vacuum - Out of memory
Date
Msg-id 3549.1138718172@sss.pgh.pa.us
Whole thread Raw
In response to Re: Vacuum - Out of memory  ("Tomeh, Husam" <htomeh@firstam.com>)
List pgsql-admin
"Tomeh, Husam" <htomeh@firstam.com> writes:
> ThanksTom. I've asked the SA to bounce the server thinking it may be a
> memory fragmentation issue on the server. After bouncing the server, I
> was able to run vacuum successfully. (Before bouncing the server, I
> tried a lower value of maintenance_work_mem of 512MB and vacuum worked
> fine which made me feel better the status of data not being corrupted).
> Do you agree with me at this point that it's not a data corruption
> issue? Thanks again.

No, I don't, unless you have fields in the database that *should* be
1-billion-and-change bytes long.

            regards, tom lane

pgsql-admin by date:

Previous
From: "Tomeh, Husam"
Date:
Subject: Re: Vacuum - Out of memory
Next
From: Düster Horst
Date:
Subject: query to select the table primary key column name