Re: Query performance issue
[
Date Prev
][
Date Next
][
Thread Prev
][
Thread Next
][
Date Index
][
Thread Index
]
Subject
: Re: Query performance issue
From
: Michael Lewis <mlewis@xxxxxxxxxxx>
Date
: Fri, 4 Sep 2020 15:41:23 -0600
Cc
: Pgsql Performance <pgsql-performance@xxxxxxxxxxxxxxxxxxxx>
In-reply-to
: <CAHOFxGo-YY-0RMzEx=JzNiu_M6fqpd1TskWDLGZ8xvfFEu813A@mail.gmail.com>
References
: <975305787.3395625.1599254321500.ref@mail.yahoo.com> <
975305787.3395625.1599254321500@mail.yahoo.com
> <
499793818.3392649.1599254645140@mail.yahoo.com
> <CAHOFxGo-YY-0RMzEx=JzNiu_M6fqpd1TskWDLGZ8xvfFEu813A@mail.gmail.com>
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
References
:
Query performance issue
From:
Nagaraj Raj
Re: Query performance issue
From:
Nagaraj Raj
Re: Query performance issue
From:
Michael Lewis
Prev by Date:
Re: Query performance issue
Next by Date:
Re: Query performance issue
Previous by thread:
Re: Query performance issue
Next by thread:
Re: Query performance issue
Index(es):
Date
Thread
[Postgresql General]
[Postgresql PHP]
[PHP Users]
[PHP Home]
[PHP on Windows]
[Kernel Newbies]
[PHP Classes]
[PHP Books]
[PHP Databases]
[Yosemite]
