dumping 8M bit fields

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.

Responses

Browse pgsql-general by date

  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