Postgres Pro
Downloads
Home   >   mailing lists

Re: Adding foreign key constraints without integrity check? - Mailing list pgsql-general

From Tom Lane
Subject Re: Adding foreign key constraints without integrity check?
Date
Msg-id 9524.1150688915@sss.pgh.pa.us
Whole thread Raw
In response to Adding foreign key constraints without integrity check?  (Wes <wespvp@syntegra.com>)
Responses Re: Adding foreign key constraints without integrity
Re: Adding foreign key constraints without integrity
List pgsql-general
Tree view 
Wes <wespvp@syntegra.com> writes:
> My database reload is currently taking about 6 hours to load the data, 42
> hours to reindex, and about another 40 hours or so to check the foreign key
> constraints (about 1.2 billion rows).

What PG version is this, and what have you got maintenance_work_mem set to?
Undersized m_w_m would hurt both index build and FK checking ...

            regards, tom lane

pgsql-general by date:

Previous
From: "Qingqing Zhou"
Date:
Subject: Re: How to optimize PostgreSQL database size
Next
From: Wes
Date:
Subject: Re: Adding foreign key constraints without integrity