Francisco Reyes <lists(at)stringsutils(dot)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