Re: BUG #6256: loading small file eats all memory and crashes system

On Fri, Oct 14, 2011 at 21:43, Rachael <rulonrasp@gmail.com> wrote:
>
> The following bug has been logged online:
>
> Bug reference: =C2=A0 =C2=A0 =C2=A06256
> Logged by: =C2=A0 =C2=A0 =C2=A0 =C2=A0 =C2=A0Rachael
> Email address: =C2=A0 =C2=A0 =C2=A0rulonrasp@gmail.com
> PostgreSQL version: 9.11
> Operating system: =C2=A0 Arch =C2=A0Linux
> Description: =C2=A0 =C2=A0 =C2=A0 =C2=A0loading small file eats all memor=
y and crashes system
> Details:
>
> While attempting to import a sql file, postgres eats all my physical memo=
ry
> (4GB) and swap file space(2GB).
>
> The file itself is a series of insert statements that is 10,000 rows by 1=
00
> columns wide. =C2=A0A smaller file (1000 rows) loads just fine. =C2=A0I'l=
l be glad to
> provide sample files. =C2=A0The command I'm using is inside a perl script:
>
> print `psql $database $user < postgres.sql`;

What happens when you remove perl from the equation? Or at  the very
least while doing the import have you tired looking a top or some
other tool to see where the memory is going?