Re: Faster data load - Mailing list pgsql-general

From Ron Johnson
Subject Re: Faster data load
Date
Msg-id CANzqJaAv+JAX8iTqM0mRJLfeqcXLD=p7m035UrvvrnJEWsZaSQ@mail.gmail.com
Whole thread Raw
In response to Re: Faster data load  (Lok P <loknath.73@gmail.com>)
List pgsql-general
On Fri, Sep 6, 2024 at 12:43 AM Lok P <loknath.73@gmail.com> wrote:
Also during index creation we are trying to do it multiple partitions at same time from multiple sessions.But seeing out of memory error in 5th or 6th session.

Had that same problem during pg_restore.  Reduced maintenance_work_mem and the problem went away.
 
--
Death to America, and butter sauce.
Iraq lobster!

pgsql-general by date:

Previous
From: Lok P
Date:
Subject: Re: Faster data load
Next
From: Arbol One
Date:
Subject: Re: Is there a way to change email for subscription ?