Re: pg11: Query using index, but only for half the partitions

From: Michael Lewis <mlewis(at)entrata(dot)com>
To: Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>
Cc: Stefan Knecht <knecht(dot)stefan(at)gmail(dot)com>, PostgreSQL General <pgsql-general(at)lists(dot)postgresql(dot)org>
Subject: Re: pg11: Query using index, but only for half the partitions
Date: 2020-04-23 13:16:52
Message-ID: CAHOFxGr3EUf8HaR-jWiyM9wj_RReUwiekMLycEFxUn2DjKRssg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Scott Ribe 2020-04-23 14:33:20 parameter limit
Previous Message Andreas Kretschmer 2020-04-23 10:47:28 Re: pg11: Query using index, but only for half the partitions