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 <mle...@entrata.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
