Re: 7.3.4 vacuum/analyze error - Mailing list pgsql-general

From Tom Lane
Subject Re: 7.3.4 vacuum/analyze error
Date
Msg-id 9602.1096516451@sss.pgh.pa.us
Whole thread Raw
In response to Re: 7.3.4 vacuum/analyze error  ("Ed L." <pgsql@bluepolka.net>)
Responses Re: 7.3.4 vacuum/analyze error  ("Ed L." <pgsql@bluepolka.net>)
List pgsql-general
"Ed L." <pgsql@bluepolka.net> writes:
> The table has 3 columns, one of which contains huge text values.  Yes, barf.

That shouldn't matter --- ANALYZE actually deliberately ignores
very-wide values so as not to run out of memory.

You sure you haven't changed default_statistics_target?

I'd think you'd uncovered a memory leak in ANALYZE, except that somebody
else would have found any such thing before now.  Which PG version are
you using exactly?

            regards, tom lane

pgsql-general by date:

Previous
From: Jeffrey Melloy
Date:
Subject: Out of memory errors on OS X
Next
From: Neil Conway
Date:
Subject: Re: Out of memory errors on OS X