Skip site navigation (1) Skip section navigation (2)

Re: 7.3.4 vacuum/analyze error

From: "Ed L(dot)" <pgsql(at)bluepolka(dot)net>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: 7.3.4 vacuum/analyze error
Date: 2004-09-30 02:52:57
Message-ID: 200409292052.57804.pgsql@bluepolka.net (view raw or flat)
Thread:
Lists: pgsql-general
On Wednesday September 29 2004 8:33, Ed L. wrote:
> On Wednesday September 29 2004 5:17, Tom Lane wrote:
> > "Ed L." <pgsql(at)bluepolka(dot)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 ...
>
> What am I missing?
>
> $ ulimit -a
> memory(kbytes)       unlimited
>
> $ psql -c "select name, setting from pg_settings" | egrep stats_
>  stats_block_level              | off
>  stats_command_string           | off
>  stats_reset_on_server_start    | on
>  stats_row_level                | off
>  stats_start_collector          | on
>
> $ psql -c "analyze audit"
> ERROR:  Memory exhausted in AllocSetAlloc(1189)

We actually count on those stats (stats_row_level?) in order to effectively 
autovacuum based on real changes, so turning them off would not be good.  
Is this a bug fixed in a later versions?  What might be triggering this?  
The only thing I see in common is that all the tables are frequently 
updated...

Ed


In response to

pgsql-general by date

Next:From: Tom LaneDate: 2004-09-30 02:59:14
Subject: Re: 7.3.4 vacuum/analyze error
Previous:From: Thomas F.O'ConnellDate: 2004-09-30 02:33:51
Subject: Re: EXTRACT Clarification

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group