Hi, I have a table with 8M rows and one of the fields is a bit (1024 bits) field. I am trying to dump the bit field for 8M rows to a file: psql -U cicc3 -A -F " " -t -o pubchem.fp -c "select cid,gfp from pubchem_compound; However I get out of memory for query result I am surprised since I did an equivalent query but selecting varchar field for 6.9M rows which worked fine. The machine is a 4-cpu Opteron machine, 16GB RAM. Does anybody know why this might be the case? Thanks, ------------------------------------------------------------------- Rajarshi Guha <rguha@xxxxxxxxxxx> GPG Fingerprint: 0CCA 8EE2 2EEB 25E2 AB04 06F7 1BB9 E634 9B87 56EE ------------------------------------------------------------------- A mouse is an elephant built by the Japanese.
