Re: PG8.1 - Config file check - Mailing list pgsql-admin

From Tom Lane
Subject Re: PG8.1 - Config file check
Date
Msg-id 23806.1135047103@sss.pgh.pa.us
Whole thread Raw
In response to PG8.1 - Config file check  (Chris Hoover <revoohc@gmail.com>)
Responses Re: PG8.1 - Config file check
List pgsql-admin
Chris Hoover <revoohc@gmail.com> writes:
> We are in the process of upgrading our 7.3.4 servers to 8.1, and I
> wanted to have a sanity check ran against my config file.  Do you see
> any issues with these configs?

> work_mem = 4096                 # min 64, size in KB

This seems a bit low in context, although it depends heavily on what
sort of query mix you expect, which you said nada about.

            regards, tom lane

pgsql-admin by date:

Previous
From: "Jim Nasby"
Date:
Subject: Re: file in posgres
Next
From: Dick Visser
Date:
Subject: Re: binary vs. txt dumps with pg