Postgres Pro
Downloads
Home   >   mailing lists

Re: explain plan difference - Mailing list pgsql-general

From Tom Lane
Subject Re: explain plan difference
Date
Msg-id 32632.1572877563@sss.pgh.pa.us
Whole thread Raw
In response to Re: explain plan difference  (Ravi Krishna <srkrishna@yahoo.com>)
Responses Re: explain plan difference  (Ravi Krishna <srkrishna@yahoo.com>)
List pgsql-general
Tree view 
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 by date:

Previous
From: Michael Shapiro
Date:
Subject: Re: select view definition from pg_views feature request
Next
From: Ravi Krishna
Date:
Subject: Re: explain plan difference