Re: [GENERAL] Help with details of what happens when I create a constraint NOT VALID

2014-01-24 Thread Marti Raudsepp
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

Re: [GENERAL] Help with details of what happens when I create a constraint NOT VALID

2014-01-23 Thread Torsten Förtsch
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