Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] Search on very big (partitioned) table - Mailing list pgsql-general

From Sushant Pawar
Subject Re: [GENERAL] Search on very big (partitioned) table
Date
Msg-id CAFU+HBwd7wyV34_H030hqZAcXrebRwfDLDEt2hcpXzf=c+thBg@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] Search on very big (partitioned) table  (Adam Brusselback <adambrusselback@gmail.com>)
Responses R: [GENERAL] Search on very big (partitioned) table  (Job <Job@colliniconsulting.it>)
List pgsql-general
Tree view
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 by date:

Previous
From: Merlin Moncure
Date:
Subject: Re: [GENERAL] Autovacuum stuck for hours, blocking queries
Next
From: Achilleas Mantzios
Date:
Subject: Re: [GENERAL] Streaming Replication Without Downtime