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

From: Andreas Kretschmer <andreas(at)a-kretschmer(dot)de>
To: 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:01:28
Message-ID: 83a2b0ef-1376-1873-3524-a824cb69f7f2@a-kretschmer.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Am 23.04.20 um 10:13 schrieb Stefan Knecht:
> Seq Scan on snap_20200225 s  (cost=0.00..1.19 rows=1 width=12)

the partition is very small, so it's cheaper to scan only the table (one
block) than index + table (1 + 1 block).

Regards, Andreas

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

In response to

Responses

Browse pgsql-general by date

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