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 <pie...@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 >
