Re: How can fixed and variable width columns perform similarly?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: How can fixed and variable width columns perform similarly?
Дата
Msg-id 15873.1177691157@sss.pgh.pa.us
обсуждение исходный текст
Ответ на How can fixed and variable width columns perform similarly?  ("Siddharth Anand" <sid@etsy.com>)
Ответы Re: How can fixed and variable width columns perform similarly?  ("Siddharth Anand" <sid@etsy.com>)
Список pgsql-performance
"Siddharth Anand" <sid@etsy.com> writes:
> How can a field that doesn't have a limit like "text" perform similarly to
> char varying(128), for example? At some point, we need to write data to
> disk. The more data that needs to be written, the longer the disk write
> will take, especially when it requires finding free sectors to write to.

What's your point?  If you're not going to put more than 128 characters
in the field, there's no difference in the amount of data involved.

            regards, tom lane

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

Предыдущее
От: Jim Nasby
Дата:
Сообщение: Re: Feature Request --- was: PostgreSQL Performance Tuning
Следующее
От: Richard Huxton
Дата:
Сообщение: Re: [Fwd: ] How