I use the id directly in the query, it has a low cost: -- Query 1. -- Nested Loop Semi Join (cost=2.27..280.78 rows=1 width=129) EXPLAIN SELECT * FROM view_companies_extra WHERE company_id iN ( SELECT id FROM companies WHERE id =…
My objective is to make Postgres choose a faster plan after a large table update. Before the table update, the plan PG choose is what I expect (the faster plan). However, after the update, PG chooses a slower plan (it…
I have a couple of tables in PostgreSQL 14.6, with indexes as stated here: # d uprn Table "public.uprn" Column | Type | Collation | Nullable | Default -----------+----------------------+-----------+----------+--------- uprn | text | | | postcode | text | |…