[PERFORM] psql -A (unaligned format) eats too much memory

2006-06-04 Thread Zoltan Boszormenyi
Hi, I just noticed that psql's unformatted output uses too much memory. Is it normal? It seems that psql draws all records of a query off the server before it displays or writes the output. I would expect this only with formatted output. Problem is, I have an export that produces 500'000+ record

Re: [PERFORM] psql -A (unaligned format) eats too much memory

2006-06-04 Thread Zoltan Boszormenyi
Hi, answering to myself. :-) Zoltan Boszormenyi írta: Hi, I just noticed that psql's unformatted output uses too much memory. Is it normal? It seems that psql draws all records of a query off the server before it displays or writes the output. I would expect this only with formatted output. P