From: | Rajarshi Guha <rguha(at)indiana(dot)edu> |
---|---|
To: | PostgreSQL Mailing lists <pgsql-general(at)postgresql(dot)org> |
Subject: | dumping 8M bit fields |
Date: | 2006-09-22 00:14:49 |
Message-ID: | 1158884089.7471.237.camel@localhost |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
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(at)indiana(dot)edu>
GPG Fingerprint: 0CCA 8EE2 2EEB 25E2 AB04 06F7 1BB9 E634 9B87 56EE
-------------------------------------------------------------------
A mouse is an elephant built by the Japanese.
From | Date | Subject | |
---|---|---|---|
Next Message | Brad Budge | 2006-09-22 01:57:43 | Select Cast Error |
Previous Message | Joe Kramer | 2006-09-21 20:11:32 | Re: [GENERAL] pgAdmin III v1.6 Beta 1 Released |