Postgres Pro
Downloads
Home   >   mailing lists

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 4466.1096499841@sss.pgh.pa.us
Whole thread Raw
In response to 7.3.4 vacuum/analyze error  ("Ed L." <pgsql@bluepolka.net>)
Responses Re: 7.3.4 vacuum/analyze error  ("Ed L." <pgsql@bluepolka.net>)
Re: 7.3.4 vacuum/analyze error  ("Ed L." <pgsql@bluepolka.net>)
List pgsql-general
Tree view 
"Ed L." <pgsql@bluepolka.net> writes:
> I'm getting a slew of these repeatable errors when running ANALYZE
> and/or VACUUM ANALYZE (from an autovacuum process) against a
> 7.3.4 cluster on HP-UX B.11.00:

> 2004-09-29 18:14:53.621 [520]    ERROR:  Memory exhausted in AllocSetAlloc(1189)

> Analyze: 132263832 total in 27 blocks; 2984 free (35 chunks); 132260848 used

Either increase your per-process memory limit, or reduce the statistics
targets for this table ...

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Index Analysis: Filters
Next
From: Thomas F.O'Connell
Date:
Subject: Re: Index Analysis: Filters