Re: Very large tables - Mailing list pgsql-general

From William Temperley
Subject Re: Very large tables
Date
Msg-id 439dc11e0811281046w7e08e966o8bc7cb9e9c1144ff@mail.gmail.com
Whole thread Raw
In response to Re: Very large tables  (Simon Riggs <simon@2ndQuadrant.com>)
List pgsql-general
On Fri, Nov 28, 2008 at 5:46 PM, Simon Riggs <simon@2ndquadrant.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@gmail.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

pgsql-general by date:

Previous
From: Simon Riggs
Date:
Subject: Re: Very large tables
Next
From: Ron Mayer
Date:
Subject: Re: Very large tables