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

Поиск
Список
Период
Сортировка
От Jaime Soler
Тема Re: [GENERAL] Slow queries on very big (and partitioned) table
Дата
Msg-id CAKVUGgTD4CSXG1+HToh9hkvnG7Phn_9Bvk3a3PSdqgUKPuBtuQ@mail.gmail.com
обсуждение исходный текст
Ответ на [GENERAL] Slow queries on very big (and partitioned) table  (Job <Job@colliniconsulting.it>)
Ответы R: [GENERAL] Slow queries on very big (and partitioned) table  (Job <Job@colliniconsulting.it>)
Список pgsql-general
Дерево обсуждения
Please share us an explain analyze of your query and \d+ of your table 

2017-02-20 13:33 GMT+01:00 Job <Job@colliniconsulting.it>:
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

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general

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

Предыдущее
От: Job
Дата:
Сообщение: [GENERAL] Slow queries on very big (and partitioned) table
Следующее
От: Stephen Frost
Дата:
Сообщение: Re: [GENERAL] Slow queries on very big (and partitioned) table