Re:Re: Different execution plan between PostgreSQL 8.2 and 12.5 - Mailing list pgsql-general

From gzh
Subject Re:Re: Different execution plan between PostgreSQL 8.2 and 12.5
Date
Msg-id 1e752bbc.16d3.182b4694559.Coremail.gzhcoder@126.com
Whole thread Raw
In response to Re: Different execution plan between PostgreSQL 8.2 and 12.5  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re:Re:Re: Different execution plan between PostgreSQL 8.2 and 12.5
List 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.

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: ERROR: catalog is missing 3 attribute(s) for relid 150243
Next
From: Vido Vlahinic
Date:
Subject: Monitoring multixact members growth