Re: Import Database - Mailing list pgsql-general

From Ron
Subject Re: Import Database
Date
Msg-id 78cf3a1b-f376-5971-bf77-b26185954325@gmail.com
Whole thread Raw
In response to Re: Import Database  (Andreas Kretschmer <andreas@a-kretschmer.de>)
Responses Re: Import Database
List pgsql-general
On 5/5/19 12:20 PM, Andreas Kretschmer wrote:
>
>
> Am 05.05.19 um 18:47 schrieb Sathish Kumar:
>> Is there a way to speed up the importing process by tweaking Postgresql 
>> config like maintenance_workmem, work_mem, shared_buffers etc.,
>
> sure, take the dump in custom-format and use pg_restore with -j 
> <number_of_jobs>.

Custom format or directory format?

-- 
Angular momentum makes the world go 'round.



pgsql-general by date:

Previous
From: Andreas Kretschmer
Date:
Subject: Re: Import Database
Next
From: Vijaykumar Jain
Date:
Subject: Re: [External] Re: Import Database