| 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:33:18 |
| Message-ID: | 200409292033.18491.pgsql@bluepolka.net |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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
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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Thomas F.O'Connell | 2004-09-30 02:33:51 | Re: EXTRACT Clarification |
| Previous Message | Thomas F.O'Connell | 2004-09-30 02:29:51 | Re: Index Analysis: Filters |