Postgres Pro
Downloads
Home   >   mailing lists

Re: Dumping a database that is not accepting commands? - Mailing list pgsql-admin

From bricklen
Subject Re: Dumping a database that is not accepting commands?
Date
Msg-id CAGrpgQ9TgYirUTDe6v1i_sat0j0aaAXy48nqP6cANKWAM5nqNg@mail.gmail.com
Whole thread Raw
In response to Re: Dumping a database that is not accepting commands?  (Natalie Wenz <nataliewenz@ebureau.com>)
Responses Re: Dumping a database that is not accepting commands?  (Natalie Wenz <nataliewenz@ebureau.com>)
List pgsql-admin
Tree view
On Tue, Sep 17, 2013 at 9:48 AM, Natalie Wenz <nataliewenz@ebureau.com> wrote:
 maintenance_work_mem            | 10GB
 shared_buffers                  | 128MB

maintenance_work_mem seems pretty high, and shared_buffers seems really low.  Out of curiousity, were those set as a product of internal testing which determined those were effective settings?

pgsql-admin by date:

Previous
From: Roberto Grandi
Date:
Subject: Re: Script timeout
Next
From: Natalie Wenz
Date:
Subject: Re: Dumping a database that is not accepting commands?