Postgres Pro
Downloads
Home   >   mailing lists

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

From Adam Brusselback
Subject Re: [GENERAL] Search on very big (partitioned) table
Date
Msg-id CAMjNa7ffVJHFrT6Rgc-74r-MLZm1hGWkQucgfmtBuPfvL-0_Mw@mail.gmail.com
Whole thread Raw
In response to [GENERAL] Search on very big (partitioned) table  ("Collini, ColliniConsulting.it" <Collini@colliniconsulting.it>)
Responses Re: [GENERAL] Search on very big (partitioned) table  (Sushant Pawar <sushant.pawar@ashnik.com>)
List pgsql-general
Tree view
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: Tom Lane
Date:
Subject: Re: [GENERAL] Using xmin and xmax for optimistic locking
Next
From: Karsten Hilbert
Date:
Subject: Re: [GENERAL] Using xmin and xmax for optimistic locking