Re: Table DDL Causing All Tables To Be Hit During Query

From: Rosser Schwarz <rosser(dot)schwarz(at)gmail(dot)com>
To: Samuel Stearns <SStearns(at)internode(dot)com(dot)au>
Cc: "pgsql-admin(at)postgresql(dot)org" <pgsql-admin(at)postgresql(dot)org>
Subject: Re: Table DDL Causing All Tables To Be Hit During Query
Date: 2013-04-16 07:26:06
Message-ID: CAFnxYwh920NCJRM=MDK8qogXLeSR_knRyLmp0-TRhSh43eP9LQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> We have tried dropping the constrainst and re-creating casting the
> check to timestamp rather than date but no change.

What is your constraint_exclusion setting?

If it's not enabled, try enabling it temporarily with "SET
constraint_exclusion = on" and re-run your query.

rls

--
:wq

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message Albe Laurenz 2013-04-16 07:43:09 Re: Table DDL Causing All Tables To Be Hit During Query
Previous Message Samuel Stearns 2013-04-16 05:49:03 Table DDL Causing All Tables To Be Hit During Query