From: Jeison Bedoya <jeisonb@audifarma.com.co>
To: pgsql-performance@postgresql.org
Subject: performance database for backup/restore
Date: Tue, 21 May 2013 08:18:55 -0500
Message-ID: <519B743F.7040407@audifarma.com.co> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
Hi people, i have a database with 400GB running in a server with 128Gb
RAM, and 32 cores, and storage over SAN with fiberchannel, the problem
is when i go to do a backup whit pg_dumpall take a lot of 5 hours, next
i do a restore and take a lot of 17 hours, that is a normal time for
that process in that machine? or i can do something to optimize the
process of backup/restore.
This is my current configuration
Postgres version 9.2.2
connections 1000
shared buffers 4096MB
work_mem = 2048MB
maintenance_work_mem = 2048MB
checkpoint_segments = 103
the other params are by default.
Thankyou very much
--
Atentamente,
JEISON BEDOYA DELGADO
Adm. Servidores y Comunicaciones
AUDIFARMA S.A.
--
NOTA VERDE:
No imprima este correo a menos que sea absolutamente necesario.
Ahorre papel, ayude a salvar un arbol.
--------------------------------------------------------------------
Este mensaje ha sido analizado por MailScanner
en busca de virus y otros contenidos peligrosos,
y se considera que esta limpio.
--------------------------------------------------------------------
Este texto fue anadido por el servidor de correo de Audifarma S.A.:
Las opiniones contenidas en este mensaje no necesariamente coinciden
con las institucionales de Audifarma. La informacion y todos sus
archivos Anexos, son confidenciales, privilegiados y solo pueden ser
utilizados por sus destinatarios. Si por error usted recibe este
mensaje, le ofrecemos disculpas, solicitamos eliminarlo de inmediato,
notificarle de su error a la persona que lo envio y abstenerse de
utilizar su contenido.
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
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-performance@postgresql.org
Cc: jeisonb@audifarma.com.co
Subject: Re: performance database for backup/restore
In-Reply-To: <519B743F.7040407@audifarma.com.co>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox