public inbox for [email protected]
help / color / mirror / Atom feedFrom: Ron Johnson <[email protected]>
To: pgsql-general <[email protected]>
Subject: Re: Faster data load
Date: Fri, 6 Sep 2024 01:12:23 -0400
Message-ID: <CANzqJaAv+JAX8iTqM0mRJLfeqcXLD=p7m035UrvvrnJEWsZaSQ@mail.gmail.com> (raw)
In-Reply-To: <CAKna9VYFp4Bqc8-9vyb_AbZH4xpXnVUsM_2papyw10WMpbjiOA@mail.gmail.com>
References: <CAKna9VaVsDzfOfOGu1+grStp9BBHFMKrH5DCEbbtGcQUWJ74KQ@mail.gmail.com>
<CAPnRvGswoifDeosThKM5zkFZzph5u86ozYkrETpGD=oig14pOA@mail.gmail.com>
<CAKna9VYFp4Bqc8-9vyb_AbZH4xpXnVUsM_2papyw10WMpbjiOA@mail.gmail.com>
On Fri, Sep 6, 2024 at 12:43 AM Lok P <[email protected]> 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!
view thread (9+ messages) latest in thread
reply
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: [email protected]
Cc: [email protected], [email protected]
Subject: Re: Faster data load
In-Reply-To: <CANzqJaAv+JAX8iTqM0mRJLfeqcXLD=p7m035UrvvrnJEWsZaSQ@mail.gmail.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox