Re: Out of memory... - Mailing list pgsql-admin

From Kevin Grittner
Subject Re: Out of memory...
Date
Msg-id 4F3E6BA3020000250004581A@gw.wicourts.gov
Whole thread Raw
In response to Out of memory...  ("Cassiano, Marco" <mcassiano@manord.com>)
List pgsql-admin
"Cassiano, Marco" <mcassiano@manord.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

pgsql-admin by date:

Previous
From: Steve Crawford
Date:
Subject: Re: Big difference in databasesize compared with disksize
Next
From: Reinhard Asmus
Date:
Subject: Re: Connections to the Database