On 12/19/05, Tom Lane <tgl@xxxxxxxxxxxxx> wrote: > Chris Hoover <revoohc@xxxxxxxxx> 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 > Sorry for got to mention that. We are running a typical OLTP system with some reporting done against it. What value would you recommend as a starting point for the work_mem. This value has come over verbatim from the 7.3.4 installs. Also, is it safe and/or advised to leave these at these high levels? maintenance_work_mem to 1GB (1048576) checkpoint_segements to 256 checkpoint_timeout to 1800 seconds (30 minutes) Thanks, Chris
