Postgres Pro
Downloads
Home   >   mailing lists

Re: Query performance issue - Mailing list pgsql-performance

From Michael Lewis
Subject Re: Query performance issue
Date
Msg-id CAHOFxGqJN6oaFS+VuJaYovFy_cdJoPw35Q7bEJ6k=Mxnrq=Bng@mail.gmail.com
Whole thread Raw
In response to Re: Query performance issue  (Michael Lewis <mlewis@entrata.com>)
List pgsql-performance
Tree view
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

pgsql-performance by date:

Previous
From: Michael Lewis
Date:
Subject: Re: Query performance issue
Next
From: Nagaraj Raj
Date:
Subject: Re: Query performance issue