Re: Out of memory...

From: "Kevin Grittner" <Kevin(dot)Grittner(at)wicourts(dot)gov>
To: "Marco Cassiano" <mcassiano(at)manord(dot)com>, <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Out of memory...
Date: 2012-02-17 21:00:51
Message-ID: 4F3E6BA3020000250004581A@gw.wicourts.gov
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

"Cassiano, Marco" <mcassiano(at)manord(dot)com> wrote:

> There was an autovaccum running on a big table saying it was "to
> avoid xid wraparound"

> My configuration is :
>
> Postgresql 9.1.2 compiled and running on Redhat 5 64 bit
> DB Size : about 100 GB
>
> RAM 5 GB
> Shared Buffers 1 GB
> temp_buffers = 8MB
> work_mem = 12MB
> maintenance_work_mem = 300MB

Are those the only settings changed from their defaults? If not, or
you're not sure, please post the output from running the query on
this page:

http://wiki.postgresql.org/wiki/Server_Configuration

-Kevin

In response to

Responses

Browse pgsql-admin by date

  From Date Subject
Next Message Raghavendra 2012-02-20 07:33:58 Re: Connections to the Database
Previous Message Steve Crawford 2012-02-17 18:00:36 Re: Big difference in databasesize compared with disksize