Re: explain plan difference

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: explain plan difference
Дата
Msg-id 32632.1572877563@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: explain plan difference  (Ravi Krishna <srkrishna@yahoo.com>)
Ответы Re: explain plan difference
Список pgsql-general
Ravi Krishna <srkrishna@yahoo.com> writes:
>> On Nov 3, 2019, at 11:03 PM, Steve Baldwin <steve.baldwin@gmail.com> wrote:
>> Thanks very much for the explanation Tom !!  You are correct - there are dropped columns in the original.

> Just to confirm, we are talking about tables from where some cols were deleted in the past, but
> VACUUM FULL not run on that table, right ?

VACUUM would not change the state of the dropped columns.

            regards, tom lane



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

Предыдущее
От: Michael Shapiro
Дата:
Сообщение: Re: select view definition from pg_views feature request
Следующее
От: Ravi Krishna
Дата:
Сообщение: Re: explain plan difference