Postgres Pro
Downloads
Home   >   mailing lists

Re: Different execution plan between PostgreSQL 8.4 and 12.11 - Mailing list pgsql-general

From Tom Lane
Subject Re: Different execution plan between PostgreSQL 8.4 and 12.11
Date
Msg-id 3810464.1665331329@sss.pgh.pa.us
Whole thread Raw
In response to Different execution plan between PostgreSQL 8.4 and 12.11  (gzh <gzhcoder@126.com>)
Responses Re:Re: Different execution plan between PostgreSQL 8.4 and 12.11
List pgsql-general
Tree view 
gzh <gzhcoder@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

pgsql-general by date:

Previous
From: Guillaume Lelarge
Date:
Subject: Re: recovery.conf and archive files
Next
From: Mladen Gogala
Date:
Subject: Re: Different execution plan between PostgreSQL 8.4 and 12.11