Postgres Pro
Downloads
Home   >   mailing lists

alter table type from double precision to real - Mailing list pgsql-general

From ssoo@siliconfile.com
Subject alter table type from double precision to real
Date
Msg-id 20070625095130.epfk3o3nqcowo4g4@mail
Whole thread Raw
Responses Re: alter table type from double precision to real  (Michael Fuhr <mike@fuhr.org>)
Re: alter table type from double precision to real  (Gregory Stark <stark@enterprisedb.com>)
List pgsql-general
Tree view 
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

pgsql-general by date:

Previous
From: danmcb
Date:
Subject: Re: finding items with 0 rels for a 0 to many relationship
Next
From: Michael Fuhr
Date:
Subject: Re: alter table type from double precision to real