Re: Are there plans to add data compression feature to postgresql? - Mailing list pgsql-general

From Grzegorz Jaśkiewicz
Subject Re: Are there plans to add data compression feature to postgresql?
Date
Msg-id 2f4958ff0810290835x52bb02f7vab6eed5306027213@mail.gmail.com
Whole thread Raw
In response to Re: Are there plans to add data compression feature to postgresql?  (小波 顾 <guxiaobo1982@hotmail.com>)
Responses Re: Are there plans to add data compression feature to postgresql?  (小波 顾 <guxiaobo1982@hotmail.com>)
List pgsql-general


2008/10/29 小波 顾 <guxiaobo1982@hotmail.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

pgsql-general by date:

Previous
From: Tomasz Myrta
Date:
Subject: Re: How can I tell, in a trigger, if a value in a string is an integer.
Next
From: "Thom Brown"
Date:
Subject: Can't restart Postgres