Re: Speed & Memory Management
От | Juan Miguel |
---|---|
Тема | Re: Speed & Memory Management |
Дата | |
Msg-id | 200304022313.17633.juanmime@ono.com обсуждение исходный текст |
Ответ на | Speed & Memory Management ("Kris" <kkiger@depauw.edu>) |
Ответы |
Re: Speed & Memory Management
Re: Speed & Memory Management |
Список | 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.
В списке pgsql-admin по дате отправления: