gzh <gzhco...@126.com> writes: > I run following sql in PostgreSQL 8.4 and PostgreSQL 12.11, it returns > different execution plan.
Have you done an ANALYZE in the new database? The rowcount estimates
seem a lot different, leading me to guess that the newer installation
doesn't have good statistics yet.
regards, tom lane
