Postgres Pro
Downloads
Home   >   mailing lists

Re: Bitmap Heap Scan taking ~60x as long for table when queried aspartition - Mailing list pgsql-novice

From Laurenz Albe
Subject Re: Bitmap Heap Scan taking ~60x as long for table when queried aspartition
Date
Msg-id 1518510158.2525.0.camel@cybertec.at
Whole thread Raw
In response to Bitmap Heap Scan taking ~60x as long for table when queried aspartition  (Stephen Froehlich <s.froehlich@cablelabs.com>)
Responses RE: Bitmap Heap Scan taking ~60x as long for table when queried aspartition  (Stephen Froehlich <s.froehlich@cablelabs.com>)
List pgsql-novice
Tree view 
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

pgsql-novice by date:

Previous
From: Stephen Froehlich
Date:
Subject: Bitmap Heap Scan taking ~60x as long for table when queried aspartition
Next
From: J B
Date:
Subject: WAL settings