MIME-Version: 1.0
References: <CAKna9VaVsDzfOfOGu1+grStp9BBHFMKrH5DCEbbtGcQUWJ74KQ@mail.gmail.com>
 <CAPnRvGswoifDeosThKM5zkFZzph5u86ozYkrETpGD=oig14pOA@mail.gmail.com> <CAKna9VYFp4Bqc8-9vyb_AbZH4xpXnVUsM_2papyw10WMpbjiOA@mail.gmail.com>
In-Reply-To: <CAKna9VYFp4Bqc8-9vyb_AbZH4xpXnVUsM_2papyw10WMpbjiOA@mail.gmail.com>
From: Ron Johnson <ronljohnsonjr@gmail.com>
Date: Fri, 6 Sep 2024 01:12:23 -0400
Message-ID: <CANzqJaAv+JAX8iTqM0mRJLfeqcXLD=p7m035UrvvrnJEWsZaSQ@mail.gmail.com>
Subject: Re: Faster data load
To: pgsql-general <pgsql-general@lists.postgresql.org>
Content-Type: multipart/alternative; boundary="0000000000007ae10506216c74fe"
Archived-At: <https://www.postgresql.org/message-id/CANzqJaAv%2BJAX8iTqM0mRJLfeqcXLD%3Dp7m035UrvvrnJEWsZaSQ%40mail.gmail.com>
Precedence: bulk

--0000000000007ae10506216c74fe
Content-Type: text/plain; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

On Fri, Sep 6, 2024 at 12:43=E2=80=AFAM 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.

--=20
Death to America, and butter sauce.
Iraq lobster!

--0000000000007ae10506216c74fe
Content-Type: text/html; charset="UTF-8"
Content-Transfer-Encoding: quoted-printable

<div dir=3D"ltr"><div dir=3D"ltr">On Fri, Sep 6, 2024 at 12:43=E2=80=AFAM L=
ok P &lt;<a href=3D"mailto:loknath.73@gmail.com">loknath.73@gmail.com</a>&g=
t; wrote:</div><div class=3D"gmail_quote"><blockquote class=3D"gmail_quote"=
 style=3D"margin:0px 0px 0px 0.8ex;border-left:1px solid rgb(204,204,204);p=
adding-left:1ex"><div dir=3D"auto"><div dir=3D"auto"> Also during index cre=
ation 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.</div></div>=
</blockquote><div><br></div><div>Had that same problem during=C2=A0pg_resto=
re.=C2=A0 Reduced maintenance_work_mem and the problem went away.</div><div=
>=C2=A0</div></div><span class=3D"gmail_signature_prefix">-- </span><br><di=
v dir=3D"ltr" class=3D"gmail_signature"><div dir=3D"ltr">Death to America, =
and butter sauce.<div>Iraq lobster!</div></div></div></div>

--0000000000007ae10506216c74fe--