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

Поиск
Список
Период
Сортировка
От Laurenz Albe
Тема Re: Bitmap Heap Scan taking ~60x as long for table when queried aspartition
Дата
Msg-id 1518510158.2525.0.camel@cybertec.at
обсуждение исходный текст
Ответ на Bitmap Heap Scan taking ~60x as long for table when queried aspartition  (Stephen Froehlich <s.froehlich@cablelabs.com>)
Ответы RE: Bitmap Heap Scan taking ~60x as long for table when queried aspartition  (Stephen Froehlich <s.froehlich@cablelabs.com>)
Список 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

В списке pgsql-novice по дате отправления:

Предыдущее
От: Stephen Froehlich
Дата:
Сообщение: Bitmap Heap Scan taking ~60x as long for table when queried aspartition
Следующее
От: J B
Дата:
Сообщение: WAL settings