Re: psql freezes loading large file - Mailing list pgsql-general

From Tom Lane
Subject Re: psql freezes loading large file
Date
Msg-id 16445.1148344220@sss.pgh.pa.us
Whole thread Raw
In response to psql freezes loading large file  (Francisco Reyes <lists@stringsutils.com>)
List pgsql-general
Francisco Reyes <lists@stringsutils.com> writes:
> I have a test ".sql" file of the form:
> insert into testtable values ('1');
> insert into testtable values ('2');
> insert into testtable values ('3');
> ....
> 100 Million

I don't have the patience to run this for 10^8 rows, but the test case
I did run showed absolutely zero memory growth in either psql or the
backend.  Are you using any nonstandard psql options?

            regards, tom lane

pgsql-general by date:

Previous
From: Francisco Reyes
Date:
Subject: psql freezes loading large file
Next
From: "Joshua D. Drake"
Date:
Subject: Re: Why won't it index scan?