Re: unexpected plan with id = any('{}') condition

2021-11-11 Thread Tom Lane
Sergei Kornilov writes: >> unreadable HTML mess > ouch, sorry. "Nobody uses plain text mail, we dropped this thing in the > interface” said yandex team. I'll confess to being a troglodyte, but it's unreadable in the archives too [1], so there was some misconfiguration somewhere.

Re: unexpected plan with id = any('{}') condition

2021-11-11 Thread Tom Lane
Sergei Kornilov writes: > [ unreadable HTML mess ] For the archives, the test case here looks like create table test (id int not null, status text); insert into test select i, 'foo' from generate_series(1,100) i; update test set status = 'bar' where id <= 10; create index test_id on test (id

unexpected plan with id = any('{}') condition

2021-11-11 Thread Sergei Kornilov
Hello I have such case: create table test (id int not null, status text);insert into test select i, 'foo' from generate_series(1,100) i;update test set status = 'bar' where id <= 10;create index test_id on test (id );create index test_status_partial on test (status) where status = 'bar';analyze