Request a Demo
Home   >   mailing lists

Re: table contraints checks only happen in planner phase - Mailing list pgsql-performance

From Josh Berkus
Subject Re: table contraints checks only happen in planner phase
Date
Msg-id 4D960C28.9020401@agliodbs.com
Whole thread Raw
In response to table contraints checks only happen in planner phase  (Joseph Shraibman <jks@selectacast.net>)
List pgsql-performance
Tree view 
On 3/31/11 5:41 PM, Joseph Shraibman wrote:
> Is there a reason that when executing queries the table constraints are
> only checked during planning and not execution?  I end up making 2 round
> trips to the database to get around this.

This is a limitation with our current partitioning implementation.  It
only understands literal values, not JOINs.

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

pgsql-performance by date:

Previous
From: Greg Smith
Date:
Subject: Re: COPY with high # of clients, partitioned table locking issues?
Next
From: Eliot Gable
Date:
Subject: C on Client versus C on Server