Re: 7.3.4 vacuum/analyze error

On Wednesday September 29 2004 5:17, Tom Lane wrote:
> "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 ...

What am I missing?

$ ulimit -a
time(seconds)        unlimited
file(blocks)         unlimited
data(kbytes)         131072
stack(kbytes)        8192
memory(kbytes)       unlimited
coredump(blocks)     4194303
nofiles(descriptors) 120

$ 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)