Re: char() or varchar() for frequently used column
От
Josh Berkus
Тема
Re: char() or varchar() for frequently used column
Дата
Msg-id
web-1790025@davinci.ethosmedia.com
Ответ на
char() or varchar() for frequently used column (Jules Alberts)
Список
Дерево обсуждения
Re: char() or varchar() for frequently used column "paul butler" <paul@entropia.co.uk>
Re: char() or varchar() for frequently used column "Jules Alberts" <jules.alberts@arbodienst-limburg.nl>
Re: char() or varchar() for frequently used column Randy Neumann <Randy_Neumann@centralref.com>
Re: char() or varchar() for frequently used column "Jules Alberts" <jules.alberts@arbodienst-limburg.nl>
Re: char() or varchar() for frequently used column Bruno Wolff III <bruno@wolff.to>
Jules, > Are there any flaws in this approach? Will I get in trouble when > using > indexes. Will performance be hampered severely? (we're not talking > about huge amounts of transactions) On postgresql, there is no performance difference between CHAR and VARCHAR. And a VARCHAR(25) which only has 1 character in each row is no slower than a VARCHAR(2) that has only one character. -Josh Berkus
В списке pgsql-novice по дате отправления
