Hi Michael,
I appreciate your question. I ran a vacuum analyze on the 9.6 table and it
yielded no difference. Same number of buffers were read, same query plan.
Thanks,
Shira
On Mon, Jan 13, 2020 at 10:07 AM Michael Lewis <mlewis(at)entrata(dot)com> wrote:
> I am not at all familiar with PostGIS so perhaps this is a silly question,
> is bloat an issue on the older instance? Correlation isn't causation, but
> half the buffers scanned and half the runtime in the v12 plan has me
> curious why that might be.
>
>>
--
Shira Bezalel
Database Administrator & Desktop Support Manager
San Francisco Estuary Institute
www.sfei.org
Ph: 510-746-7304