Re: Query performance issue

From: Michael Lewis <mlewis(at)entrata(dot)com>
To: Nagaraj Raj <nagaraj(dot)sf(at)yahoo(dot)com>
Cc: Pgsql Performance <pgsql-performance(at)lists(dot)postgresql(dot)org>
Subject: Re: Query performance issue
Date: 2020-09-04 21:41:23
Message-ID: CAHOFxGqJN6oaFS+VuJaYovFy_cdJoPw35Q7bEJ6k=Mxnrq=Bng@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

Note- you may need to vacuum* the table to get full benefit of index only
scan by updating the visibility map. I think index only scan is skipped in
favor of just checking visibility when the visibility map is stale.

*NOT full

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Nagaraj Raj 2020-09-04 21:44:14 Re: Query performance issue
Previous Message Michael Lewis 2020-09-04 21:39:12 Re: Query performance issue