Postgres Pro
Downloads
Home   >   mailing lists

Re: [GENERAL] Question about paritioning - Mailing list pgsql-general

From Alex Samad
Subject Re: [GENERAL] Question about paritioning
Date
Msg-id CAJ+Q1PX2R4GEDZW+64XWW48odvv2WYtPH3JPL=p789ead3T7Mw@mail.gmail.com
Whole thread Raw
In response to Re: [GENERAL] Question about paritioning  (John R Pierce <pierce@hogranch.com>)
List pgsql-general
Tree view
so I have a pgsql function that will create tables based on YYYYMD for x years in advance and inherits of base table.
with this
CHECK (_received >= '2013-01-01 00:00:00+11'::timestamp with time zone AND _received < '2013-02-01 01:00:00+11'::timestamp with time zone)

now for the insert, do I create / update this monthly have had a 2 or 3 level if then check before inserting

or do I create a programatic insert that works out the table name

On 27 July 2017 at 18:36, John R Pierce <pierce@hogranch.com> wrote:
On 7/27/2017 12:43 AM, Alex Samad wrote:

... as long as the queries stay on a small amount of parts that we should be okay.

thats true as long as the planner can restrict the queries to the correct partition...  but there's lots of queries that end up having to hit all partitions because the planner can't guess correctly.



--
john r pierce, recycling bits in santa cruz



--
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 by date:

Previous
From: Jeff Janes
Date:
Subject: Re: [GENERAL] Index Only Scan and Heap Fetches
Next
From: Igor Korot
Date:
Subject: [GENERAL] Why am I getting doubles?