On Thu, Jan 23, 2014 at 3:46 PM, Bill Moran wrote:
> It was suggested that
> leaving the constraints as NOT VALID might affect the planner, causing
> it to use less optimal plans because it doesn't think it can trust
> the constraint. Is this true?
AFAICT the planner doesn't currently rely on FO
On 23/01/14 14:46, Bill Moran wrote:
>
> Some quickie background: I'm on a project to migrate a fairly large
> database from MySQL to PostgreSQL (~2T). As a result of a number of
> factors, I have to do it in one shot and I have a limited time window
> in which things can be down while I switch i