Re: How to do faster DML

Поиск
Список
Период
Сортировка
От Greg Sabino Mullane
Тема Re: How to do faster DML
Дата
Msg-id CAKAnmmLYTVfeiwPKURKK3qWsWHm4Cbhc5+zBY=qTsw+5bcP=KQ@mail.gmail.com
обсуждение исходный текст
Ответ на Re: How to do faster DML  (veem v <veema0000@gmail.com>)
Ответы Re: How to do faster DML
Список pgsql-general
So as I also tested the same as you posted, there has been no change in "ctid" , when I altered the column data type from 'int' to 'bigint' in the table, so that means full table rewriting won't happen in such a scenario.

No it was definitely rewritten - do not depend on the ctid to verify that. Take our word for it, or use pg_relation_filenode('int_test'); before and after, as well as pg_relation_size('int_test');

Cheers,
Greg

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

Предыдущее
От: Julien Rouhaud
Дата:
Сообщение: Re: pg_stat_activity.query_id <-> pg_stat_statements.queryid
Следующее
От: Adrian Klaver
Дата:
Сообщение: Re: How to do faster DML