Quick Links

Re: Search on very big (partitioned) table

From:	Adam Brusselback <adambrusselback(at)gmail(dot)com>
To:	"pgsql-general(at)postgresql(dot)org" <pgsql-general(at)postgresql(dot)org>
Subject:	Re: Search on very big (partitioned) table
Date:	2017-02-20 20:47:36
Message-ID:	CAMjNa7ffVJHFrT6Rgc-74r-MLZm1hGWkQucgfmtBuPfvL-0_Mw@mail.gmail.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-general

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?

In response to

Search on very big (partitioned) table at 2017-02-20 12:31:57 from Collini, ColliniConsulting.it

Responses

Re: Search on very big (partitioned) table at 2017-02-21 03:59:42 from Sushant Pawar

Browse pgsql-general by date

	From	Date	Subject
Next Message	Karsten Hilbert	2017-02-20 20:56:51	Re: Using xmin and xmax for optimistic locking
Previous Message	Tom Lane	2017-02-20 20:44:49	Re: Using xmin and xmax for optimistic locking