Re: [GENERAL] effective_cache_size and work_ram

2012-12-12 Thread a...@hsk.hk
Hi, yes it is a dedicated server. and THANKS! On 12 Dec 2012, at 3:55 PM, Pavel Stehule wrote: > hello > > 2012/12/12 a...@hsk.hk : >> Hi, >> >> I have a new server for PostgreSQL 9.2.2 with 8GB physical RAM, I want to >> turn the server with the following changes from default: >> >> max

Re: [GENERAL] effective_cache_size and work_ram

2012-12-11 Thread Pavel Stehule
hello 2012/12/12 a...@hsk.hk : > Hi, > > I have a new server for PostgreSQL 9.2.2 with 8GB physical RAM, I want to > turn the server with the following changes from default: > > max_connections = 100 # default > shared_buffers = 2048MB # change from 24MB to 2048MB as I think 24MB is not