Re: How to do faster DML

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: How to do faster DML
Дата
Msg-id CAKFQuwbfVsF71FAfQEyku7+kQhB=zh59NpUzWh6KabHFPdDZcw@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How to do faster DML  (veem v <veema0000@gmail.com>)
Список pgsql-general
On Thu, Feb 15, 2024 at 12:18 PM veem v <veema0000@gmail.com> wrote:

So one learning for me, i.e. one of the downside of fixed length data type is, with fixed length data types any future changes to it , will be a full table rewrite. And thus this sort of change for big tables will be a nightmare.

 
Yes, using the wording in the documentation, there is no such thing as a "binary coercible" change for a fixed-width data type.  Or for most types really.  Text is one of the few for which the typmod has no meaning and there are variant spellings like varchar that allow for the underlying storage representation to be the same.

David J.

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Trouble with v16 new CREATEROLE semantic
Следующее
От: Greg Sabino Mullane
Дата:
Сообщение: Re: How to do faster DML