Wes <wespvp@xxxxxxxxxxxx> 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
