From: | Juan Miguel <juanmime(at)ono(dot)com> |
---|---|
To: | pgsql-admin(at)postgresql(dot)org |
Subject: | Re: Speed & Memory Management |
Date: | 2003-04-02 21:13:17 |
Message-ID: | 200304022313.17633.juanmime@ono.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-admin |
> That would buy you absolutely nothing. char() is not faster than text.
> Instead you would make everything slower because the system would
> constantly have to pad and trim your values and it would bloat the storage
> with the extra spaces.
First, sorry about my english.
Well ... but ... reading database theory books, you can see that fixed size
records are "better" than variant size records. When the records are size
fixed, inserts, updates and deletes can recalculate easier the position of
the rest records in the pages. These books tell you that in general cases,
variant record size tables (records that have variant type colums, for
example) imply a lower performance in the system ...
Why in postgresql these things don't matter ?
Thanks.
From | Date | Subject | |
---|---|---|---|
Next Message | Peter Eisentraut | 2003-04-02 22:20:40 | Re: Speed & Memory Management |
Previous Message | lists | 2003-04-02 20:22:50 | restore time |