| From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
|---|---|
| To: | Reg Me Please <regmeplease(at)gmail(dot)com> |
| Cc: | pgsql-general <pgsql-general(at)postgresql(dot)org> |
| Subject: | Re: "Suspending" indexes and constraint updates |
| Date: | 2007-12-04 10:57:41 |
| Message-ID: | 20071204105741.GA15272@svana.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
On Tue, Dec 04, 2007 at 10:09:06AM +0100, Reg Me Please wrote:
> Is there a way to "suspend" the index updates and the constraint checks
> before the inserts in order to later re-enable them and do a reindex?
You can defer foreign key checks and possibly constraints, but unique
index checks can't be done. For really big loads it's not uncommon to
remove the constraints and indexes prior to te load.
Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Those who make peaceful revolution impossible will make violent revolution inevitable.
> -- John F Kennedy
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Reg Me Please | 2007-12-04 10:59:19 | Re: "Suspending" indexes and constraint updates |
| Previous Message | x asasaxax | 2007-12-04 10:57:15 | Re: Transaction problem |