Re: explain plan difference

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