Re: Postgresql 8.2.4 on linux-sparc problem

From: Lew <lew(at)lwsc(dot)ehost-services(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: Postgresql 8.2.4 on linux-sparc problem
Date: 2008-01-12 20:17:14
Message-ID: msadnT-NJv7XvRTanZ2dnUVZ_t2inZ2d@comcast.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Lew 2008-01-12 20:21:21 Re: Postgresql 8.2.4 on linux-sparc problem
Previous Message Marko Kreen 2008-01-12 19:53:31 Re: How to safely compare transaction id?