| From: | Vineet Deodhar <vineet(dot)deodhar(at)gmail(dot)com> |
|---|---|
| To: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: moving from MySQL to pgsql |
| Date: | 2012-10-11 09:39:09 |
| Message-ID: | CAP5=7opXTot-k_8Gmxm5SGATyCdjt10pzoLASL5b9A-UuFdojw@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Thu, Oct 11, 2012 at 3:04 PM, Craig Ringer <ringerc(at)ringerc(dot)id(dot)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)
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vineet Deodhar | 2012-10-11 09:44:50 | Re: moving from MySQL to pgsql |
| Previous Message | Craig Ringer | 2012-10-11 09:35:14 | Re: auto-increment field : in a simple way |