Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UemTB-0005Y8-V6 for pgsql-performance@arkaria.postgresql.org; Tue, 21 May 2013 13:19:14 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1UemTB-0000cG-Fk for pgsql-performance@arkaria.postgresql.org; Tue, 21 May 2013 13:19:13 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1UemTA-0000cB-Ox for pgsql-performance@postgresql.org; Tue, 21 May 2013 13:19:12 +0000 Received: from mail.audifarma.com.co ([190.14.237.212] helo=audifarm.audifarma.com.co) by magus.postgresql.org with esmtp (Exim 4.80) (envelope-from ) id 1UemT6-0004sl-FK for pgsql-performance@postgresql.org; Tue, 21 May 2013 13:19:12 +0000 Received: from [10.1.1.81] (unknown [10.1.1.81]) (Authenticated sender: jeisonb) by audifarm.audifarma.com.co (Postfix) with ESMTP id B7A4E17806A for ; Tue, 21 May 2013 08:19:03 -0500 (COT) Message-ID: <519B743F.7040407@audifarma.com.co> Date: Tue, 21 May 2013 08:18:55 -0500 From: Jeison Bedoya User-Agent: Mozilla/5.0 (Windows NT 6.1; rv:17.0) Gecko/20130509 Thunderbird/17.0.6 MIME-Version: 1.0 To: pgsql-performance@postgresql.org Subject: performance database for backup/restore Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Audifarma-MailScanner-Information: Please contact the ISP for more information X-Audifarma-MailScanner-ID: B7A4E17806A.AA56E X-Audifarma-MailScanner: Found to be clean X-Audifarma-MailScanner-From: jeisonb@audifarma.com.co X-Spam-Status: No X-Pg-Spam-Score: -0.3 (/) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org 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