The speed problem of Varchar vs. Char

Поиск
Список
Период
Сортировка
От Crystal
Тема The speed problem of Varchar vs. Char
Дата
Msg-id f6rr5k$1afj$1@news.hub.org
обсуждение исходный текст
Ответы Re: The speed problem of Varchar vs. Char  ("Josh Tolley" <eggyknap@gmail.com>)
Re: The speed problem of Varchar vs. Char  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
Hi All,

Our company need to save contact details into the PostgreSQL database. I
just begin to learn it, so I got many questions. I am not sure which
data type I should choose for website address, varchar or char. The
website address may be very long, and we also don't want to lose the
speed. Thus, the question is: if we have a large contact database, how
much slowdown or speed up will be expected if we choose variable length
rather than fixed length? Thanks forward.

Best Wishes,
Crystal

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

Предыдущее
От: Alvaro Herrera
Дата:
Сообщение: Re: Problem with autovacuum and pg_autovacuum
Следующее
От: "Martin Gainty"
Дата:
Сообщение: Re: The speed problem of Varchar vs. Char