Re: Import Database

From: Ron <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: Import Database
Date: 2019-05-05 17:26:28
Message-ID: 78cf3a1b-f376-5971-bf77-b26185954325@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vijaykumar Jain 2019-05-05 17:32:18 Re: [External] Re: Import Database
Previous Message Andreas Kretschmer 2019-05-05 17:20:29 Re: Import Database