Tom Lane wrote:
Before you get into that, try reducing these parameters:maintenance_work_mem = 1572864 work_mem = 1048576They are way too high, especially the second one.
So if 1.5 MB maintenance_work_mem and 1 MB work_mem are "way too high", why are the default values in the postgresql.conf on installation 16 MB and 1 MB, respectively?
-- Lew ---------------------------(end of broadcast)--------------------------- TIP 2: Don't 'kill -9' the postmaster
