[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgresql-general
Subject:    Re:Re:Re: Different execution plan between PostgreSQL 8.2 and 12.5
From:       gzh  <gzhcoder () 126 ! com>
Date:       2022-08-19 7:14:43
Message-ID: 5d709655.3f7f.182b4f4451e.Coremail.gzhcoder () 126 ! com
[Download RAW message or body]

[Attachment #2 (text/plain)]

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@126.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.


[Attachment #3 (text/html)]

<div style="line-height:1.7;color:#000000;font-size:14px;font-family:Arial"><div \
style="margin: 0;">Dear Adrian,</div><div style="margin: 0;">Sorry, there is an error \
in the email just replied, the version of PostgreSQL&nbsp;is wrong.</div><div \
style="margin: 0;">PostgreSQL 8.4 ¡ú PostgreSQL 8.2</div><p style="margin: \
0;"><br></p><p style="margin: 0;"><br></p><p style="margin: 0;"><br></p><p \
style="margin: 0;"><br></p><div style="position:relative;zoom:1"></div><div \
id="divNeteaseMailCard"></div><p style="margin: 0;"><br></p><p>At 2022-08-19 \
12:42:54, "gzh" &lt;gzhcoder@126.com&gt; wrote:</p><blockquote id="isReplyContent" \
style="PADDING-LEFT: 1ex; MARGIN: 0px 0px 0px 0.8ex; BORDER-LEFT: #ccc 1px \
solid"><div style="line-height:1.7;color:#000000;font-size:14px;font-family:Arial"><p>Dear \
Adrian,</p><p>I appreciate your reply. Your reply gave me a new idea,&nbsp;</p><p>it \
should not be the problem that the lower() function causes the unique index to \
fail.&nbsp;</p><p>I checked the postgresql.conf file and found that shared_buffers, \
work_mem and maintenance_work_mem are default value,&nbsp;</p><p>but in the \
postgresql.conf file of PostgreSQL 8.4, the value of these parameters are very \
large.&nbsp;</p><p>When I changed the value of these parameters to a larger value, \
the problem solved.</p></div></blockquote></div>



[prev in list] [next in list] [prev in thread] [next in thread]