On Fri, Nov 28, 2008 at 5:46 PM, Simon Riggs <[EMAIL PROTECTED]> wrote: > > I would look carefully at the number of bits required for each float > value. 4 bytes is the default, but you may be able to use less bits than > that rather than rely upon the default compression scheme working in > your favour. Custom datatypes are often good for this kind of thing. >
I might try that, thanks. On Fri, Nov 28, 2008 at 4:58 PM, Grzegorz Jaśkiewicz <[EMAIL PROTECTED]> wrote: > > Still, I wouldn't go too far down the 'compress and stick in as bytea' road, > cos it is quite slippery, even tho might look shiny at first, Thanks for the warning! Thanks for everyone's help and ideas on this. Off to experiment. Cheers Will -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general