Re: Increasing work_mem slows down query, why?

2020-03-29 Thread Pavel Stehule
po 30. 3. 2020 v 8:47 odesílatel Silvio Moioli napsal: > Dear list, > > here is a pretty contrived case where increasing work_mem produces a worse > plan, with much worse overall query time. I wonder why that is the case. > > > Problem: INSERTing a thousand new rows in a table which can easily ha

Increasing work_mem slows down query, why?

2020-03-29 Thread Silvio Moioli
Dear list, here is a pretty contrived case where increasing work_mem produces a worse plan, with much worse overall query time. I wonder why that is the case. Problem: INSERTing a thousand new rows in a table which can easily have one million rows. PK is "id", which comes from a table, and we