Re: [GENERAL] Search on very big (partitioned) table

Поиск
Список
Период
Сортировка
От Sushant Pawar
Тема Re: [GENERAL] Search on very big (partitioned) table
Дата
Msg-id CAFU+HBwd7wyV34_H030hqZAcXrebRwfDLDEt2hcpXzf=c+thBg@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] Search on very big (partitioned) table  (Adam Brusselback <adambrusselback@gmail.com>)
Ответы R: [GENERAL] Search on very big (partitioned) table  (Job <Job@colliniconsulting.it>)
Список pgsql-general
Дерево обсуждения
What is the execution plan of a query is showing? Check whether it is reading through all partitions.

Best Regards,

Sushant Pawar | Database Solution Consultant

ASHNIK TECHNOLOGY SOLUTIONS PVT. LTD.

Skype: sush_531 | T: +91 9769559995 | www.ashnik.com



On Tue, Feb 21, 2017 at 4:47 AM, Adam Brusselback <adambrusselback@gmail.com> wrote:
Do you have non overlapping check constraints on the partitions by date to allow the planner to exclude the child tables from needing to be looked at?

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

Предыдущее
От: Merlin Moncure
Дата:
Сообщение: Re: [GENERAL] Autovacuum stuck for hours, blocking queries
Следующее
От: Achilleas Mantzios
Дата:
Сообщение: Re: [GENERAL] Streaming Replication Without Downtime