From: Shridhar Daithankar <ghodechhap@ghodechhap.net>
To: grupos@carvalhaes.net
Cc: pgsql-general@postgresql.org
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] pg_restore taking 4 hours!
Date: Wed, 1 Dec 2004 19:55:23 +0530
Message-ID: <200412011955.23543.ghodechhap@ghodechhap.net> (raw)
In-Reply-To: <41ADA82A.7070405@carvalhaes.net>
References: <41ADA82A.7070405@carvalhaes.net>
On Wednesday 01 Dec 2004 4:46 pm, Rodrigo Carvalhaes wrote:
> I need to find a solution for this because I am convincing customers
> that are using SQL Server, DB2 and Oracle to change to PostgreSQL but
> this customers have databases of 5GB!!! I am thinking that even with a
> better server, the restore will take 2 days!
>
> My data:
> Conectiva Linux 10 , Kernel 2.6.8
> PostgreSQL 7.4.6.
>
> postgresql.conf modified parameters (the other parameters are the default)
> tcpip_socket = true
> max_connections = 30
> shared_buffers = 30000
> sort_mem = 4096
> vacuum_mem = 8192
> max_fsm_pages = 20000
> max_fsm_relations = 1000
Can you try bumping sort mem lot higher(basically whatever the machine can
afford) so that index creation is faster?
Just try setting sort mem for the restore session and see if it helps..
Shridhar
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: ghodechhap@ghodechhap.net, grupos@carvalhaes.net, pgsql-general@postgresql.org
Subject: Re: [PERFORM] pg_restore taking 4 hours!
In-Reply-To: <200412011955.23543.ghodechhap@ghodechhap.net>
* 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