Re: large numbers of inserts out of memory strategy

From: Brian Crowell <brian(at)fluggo(dot)com>
To: Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com>
Cc: Ted Toth <txtoth(at)gmail(dot)com>, pgsql-general <pgsql-general(at)postgresql(dot)org>
Subject: Re: large numbers of inserts out of memory strategy
Date: 2017-11-29 03:16:51
Message-ID: CAAQkdDoq2fXk+E1gtVh_rUuJ99iLGrbc7jWBNkZpGHjytf-3NA@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Tue, Nov 28, 2017 at 12:38 PM, Tomas Vondra <tomas(dot)vondra(at)2ndquadrant(dot)com
> wrote:

> So what does the script actually do? Because psql certainly is not
> running pl/pgsql procedures on it's own. We need to understand why
> you're getting OOM in the first place - just inserts alone should not
> cause failures like that. Please show us more detailed explanation of
> what the load actually does, so that we can try reproducing it.

Perhaps the script is one giant insert statement?

—Brian

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Daevor The Devoted 2017-11-29 03:30:46 Re: SV: Refreshing materialized views
Previous Message Stephen Frost 2017-11-28 23:31:53 Re: User Connecting to Remote Database