Re: Faster data load

From: Ron Johnson <ronljohnsonjr(at)gmail(dot)com>
To: pgsql-general <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: Faster data load
Date: 2024-09-06 05:12:23
Message-ID: CANzqJaAv+JAX8iTqM0mRJLfeqcXLD=p7m035UrvvrnJEWsZaSQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Fri, Sep 6, 2024 at 12:43 AM Lok P <loknath(dot)73(at)gmail(dot)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!

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Arbol One 2024-09-06 10:53:53 Re: Is there a way to change email for subscription ?
Previous Message Lok P 2024-09-06 04:42:49 Re: Faster data load