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@xxxxxxxxxxxxxx
http://www.linuxlouis.net
