Re: 7.3.4 vacuum/analyze error

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Ed L(dot)" <pgsql(at)bluepolka(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: 7.3.4 vacuum/analyze error
Date: 2004-09-30 03:54:11
Message-ID: 9602.1096516451@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

"Ed L." <pgsql(at)bluepolka(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Neil Conway 2004-09-30 04:05:34 Re: Out of memory errors on OS X
Previous Message Jeffrey Melloy 2004-09-30 03:49:44 Out of memory errors on OS X