agora inbox for pgsql-sql@postgresql.org
help / color / mirror / Atom feedFrom: Giuseppe Broccolo <giuseppe.broccolo@2ndquadrant.it>
To: pgsql-admin@postgresql.org
Subject: Re: PostgreSQL 9.2 - pg_dump out of memory when backuping a database with 300000000 large objects
Date: Tue, 01 Oct 2013 13:01:39 +0200
Message-ID: <524AAB93.7070308@2ndquadrant.it> (raw)
In-Reply-To: <524A90D1.5000109@iqbuzz.ru>
References: <524A90D1.5000109@iqbuzz.ru>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-admin>
Maybe you can performe your database changing some parameters properly:
>
> PostgreSQL configuration:
>
> listen_addresses = '*' # what IP address(es) to listen on;
> port = 5432 # (change requires restart)
> max_connections = 500 # (change requires restart)
Set it to 100, the highest value supported by PostgreSQL
> shared_buffers = 16GB # min 128kB
This value should not be higher than 8GB
> temp_buffers = 64MB # min 800kB
> work_mem = 512MB # min 64kB
> maintenance_work_mem = 30000MB # min 1MB
Given RAM 96GB, you could set it up to 4800MB
> checkpoint_segments = 70 # in logfile segments, min 1,
> 16MB each
> effective_cache_size = 50000MB
Given RAM 96GB, you could set it up to 80GB
>
Hope it can help.
Giuseppe.
--
Giuseppe Broccolo - 2ndQuadrant Italy
PostgreSQL Training, Services and Support
giuseppe.broccolo@2ndQuadrant.it | www.2ndQuadrant.it
--
Sent via pgsql-admin mailing list (pgsql-admin@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-admin
view thread (11+ messages) latest in thread
Message-ID: <524AAB93.7070308@2ndquadrant.it>
Permalink: ../524AAB93.7070308@2ndquadrant.it/
Also on: postgresql.org/message-id/524AAB93.7070308@2ndquadrant.it
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: giuseppe.broccolo@2ndquadrant.it, pgsql-admin@postgresql.org
Subject: Re: PostgreSQL 9.2 - pg_dump out of memory when backuping a database with 300000000 large objects
In-Reply-To: <524AAB93.7070308@2ndquadrant.it>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox