What do the statistics look like for an example table that the index I used vs not? Is ((instance_id)::text = 'test01'::text) rare for the tables where an index scan is happening and common for the tables where a sequential scan is chosen? How many rows in these tables generally?
- pg11: Query using index, but only for half the partitio... Stefan Knecht
- Re: pg11: Query using index, but only for half the... Andreas Kretschmer
- Re: pg11: Query using index, but only for half... Stefan Knecht
- Re: pg11: Query using index, but only for ... Andreas Kretschmer
- Re: pg11: Query using index, but only ... Michael Lewis