Re: CHECK constraints in pg_dump - Mailing list pgsql-hackers

From Christopher Kings-Lynne
Subject Re: CHECK constraints in pg_dump
Date
Msg-id 019801c2dd6c$3491c4d0$6500a8c0@fhp.internal
Whole thread Raw
In response to CHECK constraints in pg_dump  ("Christopher Kings-Lynne" <chriskl@familyhealth.com.au>)
Responses Re: CHECK constraints in pg_dump
List pgsql-hackers
> "Christopher Kings-Lynne" <chriskl@familyhealth.com.au> writes:
> > I notice that we're still dumping CHECK constraints as part of the
CREATE
> > TABLE statement, and not as an ALTER TABLE statement after the data has
been
> > loaded.
>
> > Should we move it to after the data for speed purposes, like we have
with
> > all other constraints?
>
> Why would there be any speed advantage?

Is it not faster to add it when all the data is there, rather than
evaluating it as each row is inserted, like indexes?

Chris




pgsql-hackers by date:

Previous
From: Dave Cramer
Date:
Subject: Re: autocommit off mode, how does it work?
Next
From: Darko Prenosil
Date:
Subject: Re: I cant find it or I'm just lazy ?