[GENERAL] Slow queries on very big (and partitioned) table

Поиск
Список
Период
Сортировка
От Job
Тема [GENERAL] Slow queries on very big (and partitioned) table
Дата
Msg-id 88EF58F000EC4B4684700C2AA3A73D7A08054EAEBAEE@W2008DC01.ColliniConsulting.lan
обсуждение исходный текст
Ответы Re: [GENERAL] Slow queries on very big (and partitioned) table  (Jaime Soler <jaime.soler@gmail.com>)
Re: [GENERAL] Slow queries on very big (and partitioned) table  (Stephen Frost <sfrost@snowman.net>)
Список pgsql-general
Дерево обсуждения 
Hu guys,

we have a test machine with Postgresql 9.6.1 an about 800.000.000 record in a table.
Table is partitioned by day, with indexes on partitioned table.

Also a simple query (for example i want to search log occurred in a specific day), is immediate in tha partitioned
table(table_2017_02_15) but *extremely* slow in global table. 

Where am i wrong?
Shall i create global index?

Thank you!
/F

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

Предыдущее
От: "Collini, ColliniConsulting.it"
Дата:
Сообщение: [GENERAL] Search on very big (partitioned) table
Следующее
От: Jaime Soler
Дата:
Сообщение: Re: [GENERAL] Slow queries on very big (and partitioned) table