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@xxxxxxxxxxx> 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
Ph: 510-746-7304
