On Mon, 2010-07-12 at 22:01 -0500, Josh Berkus wrote: > On 9/2/09 10:05 AM, Kevin Kempter wrote: > > On Wednesday 02 September 2009 09:02:27 Scott Marlowe wrote: > >> On Wed, Sep 2, 2009 at 8:52 AM, Kevin Kempter<kevink@xxxxxxxxxxxxxxxxxxx> > > wrote: > >>> Hi all; > >>> > >>> I cant figure out why we're scanning all of our partitions. > > I don't think extract() is immutable, which would pretty much invalidate > your check constraints as far as CE is concerned. Correct. Joshua D. Drake -- PostgreSQL.org Major Contributor Command Prompt, Inc: http://www.commandprompt.com/ - 509.416.6579 Consulting, Training, Support, Custom Development, Engineering -- Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
