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@xxxxxxxxxxxx> 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@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
