Re:Re: Different execution plan between PostgreSQL 8.2 and 12.5

From: gzh <gzhcoder(at)126(dot)com>
To: "Adrian Klaver" <adrian(dot)klaver(at)aklaver(dot)com>
Cc: "Tom Lane" <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re:Re: Different execution plan between PostgreSQL 8.2 and 12.5
Date: 2022-08-19 04:42:54
Message-ID: 1e752bbc.16d3.182b4694559.Coremail.gzhcoder@126.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Dear Adrian,

I appreciate your reply. Your reply gave me a new idea,

it should not be the problem that the lower() function causes the unique index to fail.

I checked the postgresql.conf file and found that shared_buffers, work_mem and maintenance_work_mem are default value,

but in the postgresql.conf file of PostgreSQL 8.4, the value of these parameters are very large.

When I changed the value of these parameters to a larger value, the problem solved.

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Vido Vlahinic 2022-08-19 05:16:35 Monitoring multixact members growth
Previous Message Tom Lane 2022-08-19 04:42:44 Re: ERROR: catalog is missing 3 attribute(s) for relid 150243