alter table type from double precision to real

From: ssoo(at)siliconfile(dot)com
To: pgsql-general(at)postgresql(dot)org
Subject: alter table type from double precision to real
Date: 2007-06-25 00:51:30
Message-ID: 20070625095130.epfk3o3nqcowo4g4@mail
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Real type takes 4 byte storage sizes and double precision takes 8 bytes.
I altered a data type from double precision to real and vacuumed DB.
But PostgreSQL's data disk usage did not shrinked.
And pg_dump size remained same.
It seems that real takes 8 byte storage sizes.

Here's my environments:
CPU: AMD Opteron
OS: Solaris 10
PostgreSQL: 8.2.4, compiled w/ Sun CC using 64-bit flags

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Fuhr 2007-06-25 04:16:10 Re: alter table type from double precision to real
Previous Message danmcb 2007-06-24 18:45:00 Re: how to implement unusual constraint