Re: [PERFORM] fast read of binary data

2012-11-22 Thread Heikki Linnakangas
On 22.11.2012 09:54, Eildert Groeneveld wrote: ok, I did have a look at the libpq librar, and you are right, there is a way to obtain binary data from the backend through the PQexecParams res = PQexecParams(conn, DECLARE myportal CURSOR FOR select genotype_bits

Re: [PERFORM] fast read of binary data

2012-11-21 Thread Eildert Groeneveld
On Mo, 2012-11-12 at 12:18 +0100, Albe Laurenz wrote: Eildert Groeneveld wrote: I am currently implementing using a compressed binary storage scheme genotyping data. These are basically vectors of binary data which may be megabytes in size. Our current implementation uses the data type

Re: [PERFORM] fast read of binary data

2012-11-12 Thread Albe Laurenz
Eildert Groeneveld wrote: I am currently implementing using a compressed binary storage scheme genotyping data. These are basically vectors of binary data which may be megabytes in size. Our current implementation uses the data type bit varying. What we want to do is very simple: we want

Re: [PERFORM] fast read of binary data

2012-11-12 Thread Arjen van der Meijden
On 12-11-2012 11:45, Eildert Groeneveld wrote: Dear All I am currently implementing using a compressed binary storage scheme genotyping data. These are basically vectors of binary data which may be megabytes in size. Our current implementation uses the data type bit varying. Wouldn't 'bytea'

Re: [PERFORM] fast read of binary data

2012-11-12 Thread Merlin Moncure
On Mon, Nov 12, 2012 at 4:45 AM, Eildert Groeneveld eildert.groenev...@fli.bund.de wrote: Dear All I am currently implementing using a compressed binary storage scheme genotyping data. These are basically vectors of binary data which may be megabytes in size. Our current implementation uses