Re: Postgresql 8.2.4 on linux-sparc problem - Mailing list pgsql-general

From Lew
Subject Re: Postgresql 8.2.4 on linux-sparc problem
Date
Msg-id msadnT-NJv7XvRTanZ2dnUVZ_t2inZ2d@comcast.com
Whole thread Raw
In response to Re: Postgresql 8.2.4 on linux-sparc problem  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
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

pgsql-general by date:

Previous
From: dterrors@hotmail.com
Date:
Subject: Re: A counter argument about DISTINCT and GROUP BY in PostgreSQL
Next
From: Tristen Ennemuist
Date:
Subject: libpq updateable resultset?