On Fri, Nov 28, 2008 at 5:46 PM, Simon Riggs <simon@xxxxxxxxxxxxxxx> 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 <gryzman@xxxxxxxxx> 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@xxxxxxxxxxxxxx)To make changes to your subscription:http://www.postgresql.org/mailpref/pgsql-general
