Re: Very large tables

Поиск
Список
Период
Сортировка
От William Temperley
Тема Re: Very large tables
Дата
Msg-id 439dc11e0811281046w7e08e966o8bc7cb9e9c1144ff@mail.gmail.com
обсуждение исходный текст
Ответ на Re: Very large tables  (Simon Riggs <simon@2ndQuadrant.com>)
Список 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 по дате отправления:

Предыдущее
От: Simon Riggs
Дата:
Сообщение: Re: Very large tables
Следующее
От: Ron Mayer
Дата:
Сообщение: Re: Very large tables