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

Поиск
Список
Период
Сортировка
От gzh
Тема Re:Re:Re: Different execution plan between PostgreSQL 8.2 and 12.5
Дата
Msg-id 5d709655.3f7f.182b4f4451e.Coremail.gzhcoder@126.com
обсуждение исходный текст
Ответ на Re:Re: Different execution plan between PostgreSQL 8.2 and 12.5  (gzh <gzhcoder@126.com>)
Список 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@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.

В списке pgsql-general по дате отправления:

Предыдущее
От: Vido Vlahinic
Дата:
Сообщение: Monitoring multixact members growth
Следующее
От: Vido Vlahinic
Дата:
Сообщение: RE: Monitoring multixact members growth