Re: Very high memory usage on restoring dump (with plain pqsl) on pg 9.1.2

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Heiko Wundram <modelnine(at)modelnine(dot)org>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Very high memory usage on restoring dump (with plain pqsl) on pg 9.1.2
Date: 2012-03-22 14:48:16
Message-ID: 21746.1332427696@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Heiko Wundram <modelnine(at)modelnine(dot)org> writes:
> On a host that I'm currently in the process of migrating, I'm
> experiencing massive memory usage when importing the dump (generated
> using a plain pg_dump without options) using psql. The massive memory
> usage happens when the CREATE INDEX commands are executed,

What PG version are we talking about, and what exactly is the
problematic index?

There was a memory leak in the last-but-one releases for index
operations on inet and cidr datatypes, so I'm wondering if that
explains your problem ...

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Scott Marlowe 2012-03-22 15:02:27 Re: Large PostgreSQL servers
Previous Message Merlin Moncure 2012-03-22 14:46:31 Re: Large PostgreSQL servers