Re: PostgreSQL 12.3 slow index scan chosen

2020-06-22 Thread Alvaro Herrera
On 2020-Jun-20, Tom Lane wrote: > I wrote: > > ... oh, now I see: apparently, your filter condition is such that *no* > > rows of the objectcustomfieldvalues table get past the filter: > > > > -> Index Scan using objectcustomfieldvalues3 on > > objectcustomfieldvalues objectcustomf

Re: PostgreSQL 12.3 slow index scan chosen

2020-06-22 Thread Kenneth Marshall
On Mon, Jun 22, 2020 at 03:27:32PM -0400, Alvaro Herrera wrote: > On 2020-Jun-20, Tom Lane wrote: > > > I wrote: > > > ... oh, now I see: apparently, your filter condition is such that *no* > > > rows of the objectcustomfieldvalues table get past the filter: > > > > > > -> Index Sca

Re: PostgreSQL 12.3 slow index scan chosen

2020-06-22 Thread Tom Lane
Alvaro Herrera writes: > On 2020-Jun-20, Tom Lane wrote: >> You said you'd increased the stats target for >> objectcustomfieldvalues.objectid, but maybe the real problem is needing >> to increase the targets for content and largecontent, in hopes of driving >> down the estimate for how many rows w