Re: explain plan difference

From: Ravi Krishna <srkrishna(at)yahoo(dot)com>
To: Steve Baldwin <steve(dot)baldwin(at)gmail(dot)com>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, "pgsql-generallists(dot)postgresql(dot)org pgsql-generallists(dot)postgresql(dot)org" <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: explain plan difference
Date: 2019-11-04 12:04:55
Message-ID: 46D43737-F971-440D-AB13-8EDBB89E91C1@yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


> 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 ?

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Ashok Kumar Tiwari 2019-11-04 13:35:24 Create a logical and physical replication
Previous Message Laurenz Albe 2019-11-04 04:43:58 Re: Are my autovacuum settings too aggressive for this table?