Re: explain plan difference

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ravi Krishna <srkrishna(at)yahoo(dot)com>
Cc: Steve Baldwin <steve(dot)baldwin(at)gmail(dot)com>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: explain plan difference
Date: 2019-11-04 14:26:03
Message-ID: 32632.1572877563@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ravi Krishna <srkrishna(at)yahoo(dot)com> writes:
>> On Nov 3, 2019, at 11:03 PM, Steve Baldwin <steve(dot)baldwin(at)gmail(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ravi Krishna 2019-11-04 14:32:26 Re: explain plan difference
Previous Message Michael Shapiro 2019-11-04 13:48:50 Re: select view definition from pg_views feature request