Re: Speed & Memory Management

Поиск
Список
Период
Сортировка
От Peter Eisentraut
Тема Re: Speed & Memory Management
Дата
Msg-id Pine.LNX.4.44.0304012112490.2216-100000@peter.localdomain
обсуждение исходный текст
Ответ на Speed & Memory Management  ("Kris" <kkiger@depauw.edu>)
Список pgsql-admin
Kris writes:

> My thought is that because I will likely have many
> updates/inserts/deletes occurring I should set each column that requires
> text to a static ammount (ie using char(30) instead of text).

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.

--
Peter Eisentraut   peter_e@gmx.net


В списке pgsql-admin по дате отправления:

Предыдущее
От: "Chris White"
Дата:
Сообщение: Documentation for the \lo_export and \lo_import commands
Следующее
От: Hugo Escobar
Дата:
Сообщение: Invalid UNICODE character sequence found (0xd14f)