On Fri, Oct 14, 2011 at 21:43, Rachael <rulonr...@gmail.com> wrote: > > The following bug has been logged online: > > Bug reference: 6256 > Logged by: Rachael > Email address: rulonr...@gmail.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? -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
