[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
Re: [GENERAL] Slow queries on very big (and partitioned) table
Список 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 по дате отправления: