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

From: Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>
To: Stefan Knecht <knecht(dot)stefan(at)gmail(dot)com>
Cc: pgsql-general(at)lists(dot)postgresql(dot)org
Subject: Re: pg11: Query using index, but only for half the partitions
Date: 2020-04-23 10:47:28
Message-ID: 6316e230-f315-4bc3-f74f-65e6d2fe3603@a-kretschmer.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Am 23.04.20 um 12:30 schrieb Stefan Knecht:
> There's no question that this is more expensive than just reading the
> 95 rows from the index directly and returning them

not sure, you can play with

enable_seqscan = off

and compare the costs. What is the setting for random_page_cost ?

Regards, Andreas

--
2ndQuadrant - The PostgreSQL Support Company.
www.2ndQuadrant.com

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Michael Lewis 2020-04-23 13:16:52 Re: pg11: Query using index, but only for half the partitions
Previous Message Stefan Knecht 2020-04-23 10:30:34 Re: pg11: Query using index, but only for half the partitions