Re: Very large tables

On Fri, Nov 28, 2008 at 5:46 PM, Simon Riggs <simon(at)2ndquadrant(dot)com> 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(at)gmail(dot)com> 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