Skip site navigation (1) Skip section navigation (2)

Re: Very large tables

From: "William Temperley" <willtemperley(at)gmail(dot)com>
To:
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Very large tables
Date: 2008-11-28 18:46:54
Message-ID: 439dc11e0811281046w7e08e966o8bc7cb9e9c1144ff@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-general
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

In response to

pgsql-general by date

Next:From: Ron MayerDate: 2008-11-28 19:43:31
Subject: Re: Very large tables
Previous:From: Simon RiggsDate: 2008-11-28 17:46:14
Subject: Re: Very large tables

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group