Tom Lane wrote:
> Before you get into that, try reducing these parameters:
>
>> maintenance_work_mem = 1572864
>> work_mem = 1048576
>
> They 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