From: | Viktor Bojović <viktor(dot)bojovic(at)gmail(dot)com> |
---|---|
To: | adrien ducos <aducos(at)hbs-research(dot)com> |
Cc: | "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org> |
Subject: | Re: db restore takes to long |
Date: | 2011-05-09 11:44:00 |
Message-ID: | BANLkTik2Ni8NDotj7KgsXvBwEZGEXFTSEA@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
Thanx Adrien,
i have tried to skip indexes but constraints rely on them
"there is no unique constraint matching given keys for referenced table"
, so i will try to use pg_restore as you have mentioned below.
On Mon, May 9, 2011 at 12:19 PM, adrien ducos <aducos(at)hbs-research(dot)com>wrote:
> It seams there is no option like that in pg_dump or pg_restore. But You can
> manualy do it in the dump or with a sed command finding the lines begining
> by CREATE INDEX and removing them.
>
> We also have a big database and since postgres 8.4 pg_restore is much
> faster with the option --jobs=x
>
> where x is the number of cores you have in your microprocessor. It then
> divides the restore script into different jobs and goes faster using
> multithreading.
> example:
> pg_restore --username postgres --jobs=4 --dbname=your_db_name
> your_dump_file
>
> Here is if you have a quad core.
>
> Adrien
>
>
> Viktor Bojović a écrit :
>
> Hi,
>>
>> im trying to restore 250GB database, but indexing takes too long, so
>> restore takes more then 12h.
>> Is it possible to disable indexing while restoring database?
>>
>> Thanx in advance
>>
>>
>> --
>> ---------------------------------------
>> Viktor Bojović
>> ---------------------------------------
>> Wherever I go, Murphy goes with me
>>
>
>
> --
>
> Logo_HBS_mail.jpg
> Adrien DUCOS
> Analyste développeur
> aducos(at)hbs-research(dot)com <mailto:aducos(at)hbs-research(dot)com>
> www.hbs-research.com <http://www.hbs-research.com/>
> +33 (0)9 70 44 64 10
> 24 rue de l'Est
> 75020 Paris
>
>
>
>
--
---------------------------------------
Viktor Bojović
---------------------------------------
Wherever I go, Murphy goes with me
From | Date | Subject | |
---|---|---|---|
Next Message | adrien ducos | 2011-05-09 12:03:13 | Re: db restore takes to long |
Previous Message | raghu ram | 2011-05-09 11:13:19 | Re: constraint system tables |