2016-06-20 11:30 GMT-03:00 Vik Fearing <vik@xxxxxxxxxxxxxx>: > On 20/06/16 16:23, Martín Marqués wrote: >> >> That's not entirely true. Think about a SELECT which has to scan all >> child tables. > > Or any SELECT on the parent at all. The planner needs to examine the > CHECK constraints on the children and can't do it if the child is locked > in ACCESS EXCLUSIVE mode. Yeah, totally skipped my mind that, so partitioning is actually a bad idea, if that's all they are looking to solve. Thanks Vik for showing the oversight -- Martín Marqués http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
