Postgres Pro
Downloads
Home   >   mailing lists

Re: Table DDL Causing All Tables To Be Hit During Query - Mailing list pgsql-admin

From Rosser Schwarz
Subject Re: Table DDL Causing All Tables To Be Hit During Query
Date
Msg-id CAFnxYwh920NCJRM=MDK8qogXLeSR_knRyLmp0-TRhSh43eP9LQ@mail.gmail.com
Whole thread Raw
In response to Table DDL Causing All Tables To Be Hit During Query  (Samuel Stearns <SStearns@internode.com.au>)
List pgsql-admin
Tree view
> 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

pgsql-admin by date:

Previous
From: Samuel Stearns
Date:
Subject: Table DDL Causing All Tables To Be Hit During Query
Next
From: Albe Laurenz
Date:
Subject: Re: Table DDL Causing All Tables To Be Hit During Query