On Thu, Oct 11, 2012 at 3:04 PM, Craig Ringer <ring...@ringerc.id.au> wrote:
> > AFAIK in most situations alignment requirements will mean you won't gain > any space in those situations anyway. > > I would be truly amazed if you saw more than something like a 1% > difference in size due to this; it'll be *massively* outweighed by all the > other differences. You're optimising prematurely. See if it's a problem in > practice, and if it is look into using a custom data type (warning: lots of > work) or some other approach. > -- > Craig Ringer > > OK. As per your advise, let me put smallint into practice and analyze the storage requirement. Thanks a lot. -- Vineet -- Best regards, Vineet Deodhar 0 9270012422 ( Sales) 0 9420 6767 41 / 0 844 6268 488 (Service) 0233-2300136 (Back-Office)