Postgres Pro
Downloads
Home   >   mailing lists

Re: pg11: Query using index, but only for half the partitions - Mailing list pgsql-general

From Andreas Kretschmer
Subject Re: pg11: Query using index, but only for half the partitions
Date
Msg-id 6316e230-f315-4bc3-f74f-65e6d2fe3603@a-kretschmer.de
Whole thread Raw
In response to Re: pg11: Query using index, but only for half the partitions  (Stefan Knecht <knecht.stefan@gmail.com>)
Responses Re: pg11: Query using index, but only for half the partitions
List pgsql-general
Tree view 

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

pgsql-general by date:

Previous
From: Stefan Knecht
Date:
Subject: Re: pg11: Query using index, but only for half the partitions
Next
From: Michael Lewis
Date:
Subject: Re: pg11: Query using index, but only for half the partitions