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

On Fri, Oct 14, 2011 at 21:43, Rachael <rulonrasp(at)gmail(dot)com> wrote:
>
> The following bug has been logged online:
>
> Bug reference:      6256
> Logged by:          Rachael
> Email address:      rulonrasp(at)gmail(dot)com
> PostgreSQL version: 9.11
> Operating system:   Arch  Linux
> Description:        loading small file eats all memory and crashes system
> Details:
>
> While attempting to import a sql file, postgres eats all my physical memory
> (4GB) and swap file space(2GB).
>
> The file itself is a series of insert statements that is 10,000 rows by 100
> columns wide.  A smaller file (1000 rows) loads just fine.  I'll be glad to
> provide sample files.  The 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?