Re: Bitmap Heap Scan taking ~60x as long for table when queried as partition

From: Laurenz Albe <laurenz(dot)albe(at)cybertec(dot)at>
To: Stephen Froehlich <s(dot)froehlich(at)cablelabs(dot)com>, "pgsql-novice(at)postgresql(dot)org" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Bitmap Heap Scan taking ~60x as long for table when queried as partition
Date: 2018-02-13 08:22:38
Message-ID: 1518510158.2525.0.camel@cybertec.at
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

Stephen Froehlich wrote:
> I have a fairly large partitioned table, but annoyingly if I query the hypertable directly
> it takes ~60x as long to scan each subtable than if I query each sub-table directly.
> I have freshly vacuumed and analyzed the tables in question and this persists.
> What is going on?

Can you send the complete execution plan for the second query?

Yours,
Laurenz Albe

In response to

Responses

Browse pgsql-novice by date

  From Date Subject
Next Message J B 2018-02-14 12:33:02 WAL settings
Previous Message Stephen Froehlich 2018-02-12 16:47:15 Bitmap Heap Scan taking ~60x as long for table when queried as partition