You could try removing/disabling your constraints until after the import/index building.
SET CONSTRAINTS ALL DEFERRED On Mon, May 9, 2011 at 7:44 AM, Viktor Bojović <viktor.bojo...@gmail.com>wrote: > 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 <adu...@hbs-research.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 >> adu...@hbs-research.com <mailto:adu...@hbs-research.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 > -- Noodle Connecting People, Content & Capabilities within the Enterprise Toll Free: 866-258-6951 x 701 tim.le...@vialect.com http://www.vialect.com Noodle is a product of Vialect Inc Follow Noodle on Twitter http://www.twitter.com/noodle_news
