You should use varchar(20), which will not consume as much space as
char(20) IF the values inserted don't, themselves take the full 20
positions. In varchar, there will be no padding, thus saving on your disk
space.
For your question in particular, that depends on the block size of how PG
allocates space on tables.
On Wed, 12 Jul 2006, Umamaheswaran Srinivasan wrote:
> I w'd like how the DB growth impacts the actual disk
> space. For example, I have a table with one textfield,
> char(20) and I insert 1000000 records. My DB size w'd
> be approximately,
> 20+28(Overhead)=48*1000000=48MB. What is the actual
> effect on the physical HDD. I w'd appreciate your
> help.
> Thanks,
> Uma
>
>
> __________________________________________________
> Do You Yahoo!?
> Tired of spam? Yahoo! Mail has the best spam protection around
> http://mail.yahoo.com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: Don't 'kill -9' the postmaster
>
--
Louis Gonzales
louis.gonzales@linuxlouis.net
http://www.linuxlouis.net
