Re: Memory Usage and OpenBSD

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jeff Ross <jross(at)wykids(dot)org>
Cc: PostgreSQL <pgsql-general(at)postgresql(dot)org>
Subject: Re: Memory Usage and OpenBSD
Date: 2010-01-27 22:35:48
Message-ID: 15486.1264631748@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Jeff Ross <jross(at)wykids(dot)org> writes:
> Running a simple select only pgbench test against it will fail with an out of
> memory error as it tries to vacuum --analyze the newly created database with
> 7500000 tuples.

Better look at the "ulimit" values the postmaster is started with;
you shouldn't be getting that out-of-memory error AFAICS, unless
there's a very restrictive ulimit on what an individual process can
allocate.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Mike Bresnahan 2010-01-27 22:37:49 Re: Amazon EC2 CPU Utilization
Previous Message Jeff Ross 2010-01-27 21:59:08 Memory Usage and OpenBSD