Re:Re: Different execution plan between PostgreSQL 8.4 and 12.11

From: gzh <gzhcoder(at)126(dot)com>
To: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re:Re: Different execution plan between PostgreSQL 8.4 and 12.11
Date: 2022-10-10 02:32:56
Message-ID: 3bb0d13f.1d81.183bfbcf7e4.Coremail.gzhcoder@126.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi Tom,

Thank you for your prompt response.
I've run analyze(not vacuum analyze), but it doesn't seem to work.
Is there any other way to optimize the database?

At 2022-10-10 00:02:09, "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us> wrote:
>gzh <gzhcoder(at)126(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Peter Smith 2022-10-10 02:38:26 Re: Support logical replication of DDLs
Previous Message Mark Fletcher 2022-10-09 16:56:59 Logical replication/publication question