| 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:Re: Different execution plan between PostgreSQL 8.2 and 12.5 |
| Date: | 2022-08-19 07:14:43 |
| Message-ID: | 5d709655.3f7f.182b4f4451e.Coremail.gzhcoder@126.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
Dear Adrian,
Sorry, there is an error in the email just replied, the version of PostgreSQL is wrong.
PostgreSQL 8.4 → PostgreSQL 8.2
At 2022-08-19 12:42:54, "gzh" <gzhcoder(at)126(dot)com> wrote:
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.
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Vido Vlahinic | 2022-08-19 07:52:15 | RE: Monitoring multixact members growth |
| Previous Message | Vido Vlahinic | 2022-08-19 05:16:35 | Monitoring multixact members growth |