Re: Are there plans to add data compression feature to postgresql?

From: Grzegorz Jaśkiewicz <gryzman(at)gmail(dot)com>
To: 小波 顾 <guxiaobo1982(at)hotmail(dot)com>
Cc: chris(dot)ellis(at)shropshire(dot)gov(dot)uk, "pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject: Re: Are there plans to add data compression feature to postgresql?
Date: 2008-10-29 15:35:44
Message-ID: 2f4958ff0810290835x52bb02f7vab6eed5306027213@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

2008/10/29 小波 顾 <guxiaobo1982(at)hotmail(dot)com>

> 1. Little integers of types take 8 bytes in the past now only take 4 or 2
> bytes if there are not so large.
>
So what actually happen if I have a table with few mills of values that fit
in 2 bytes, but all of the sudent I am going to add another column with
something that requires 8 bytes ? update on all columns ? I am actually even
against varchars in my databases, so something like that sounds at least
creepy.

--
GJ

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Thom Brown 2008-10-29 15:43:06 Can't restart Postgres
Previous Message 小波 顾 2008-10-29 15:26:28 Re: Are there plans to add data compression feature to postgresql?