Re: An out of memory error when doing a vacuum full

From: Fernando Schapachnik <fernando(at)mecon(dot)gov(dot)ar>
To: Sean Shanny <shannyconsulting(at)earthlink(dot)net>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: An out of memory error when doing a vacuum full
Date: 2003-12-29 16:25:38
Message-ID: 20031229162538.GI344@bal740r0.mecon.gov.ar
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Is your system using full RAM? Ie, what does limits -a show?

Regards.

Fernando.

En un mensaje anterior, Sean Shanny escribió:
> To all,
>
> The facts:
>
> PostgreSQL 7.4.0 running on BSD 5.1 on Dell 2650 with 4GB RAM, 5 SCSI
> drives in hardware RAID 0 configuration. Database size with indexes is
> currently 122GB. DB size before we completed the vacuum full was 150GB.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Fernando Schapachnik 2003-12-29 16:41:21 Re: An out of memory error when doing a vacuum full
Previous Message Dave Cramer 2003-12-29 16:21:00 Re: Is my MySQL Gaining ?