Re: Very high memory usage on restoring dump (with plain pqsl) on pg 9.1.2 - Mailing list pgsql-general

From Tom Lane
Subject Re: Very high memory usage on restoring dump (with plain pqsl) on pg 9.1.2
Date
Msg-id 21746.1332427696@sss.pgh.pa.us
Whole thread Raw
In response to Very high memory usage on restoring dump (with plain pqsl) on pg 9.1.2  (Heiko Wundram <modelnine@modelnine.org>)
Responses Re: Very high memory usage on restoring dump (with plain pqsl) on pg 9.1.2
List pgsql-general
Heiko Wundram <modelnine@modelnine.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

pgsql-general by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: Large PostgreSQL servers
Next
From: Scott Marlowe
Date:
Subject: Re: Large PostgreSQL servers