Re: [PERFORM] Increased shared_buffer setting = lower hit ratio ?

On Thu, Nov 13, 2014 at 3:09 PM, CS DBA wrote: > All; > > We have a large db server with 128GB of ram running complex functions. > > with the server set to have the following we were seeing a somewhat low > hit ratio and lots of temp buffers > > shared_buffers = 18GB > work_mem = 75MB > effective

Re: [PERFORM] Increased shared_buffer setting = lower hit ratio ?

Hi, On 14.11.2014 00:16, CS DBA wrote: > This is on a CentOS 6.5 box running PostgreSQL 9.2 > > > On 11/13/14 4:09 PM, CS DBA wrote: >> All; >> >> We have a large db server with 128GB of ram running complex >> functions. >> >> with the server set to have the following we were seeing a >> somewha

Re: [PERFORM] Increased shared_buffer setting = lower hit ratio ?

This is on a CentOS 6.5 box running PostgreSQL 9.2 On 11/13/14 4:09 PM, CS DBA wrote: All; We have a large db server with 128GB of ram running complex functions. with the server set to have the following we were seeing a somewhat low hit ratio and lots of temp buffers shared_buffers = 18GB

[PERFORM] Increased shared_buffer setting = lower hit ratio ?

All; We have a large db server with 128GB of ram running complex functions. with the server set to have the following we were seeing a somewhat low hit ratio and lots of temp buffers shared_buffers = 18GB work_mem = 75MB effective_cache_size = 105GB checkpoint_segments = 128 when we increas

[PERFORM] 9.0 performance degradation with kernel 3.11

Hi After upgrading our 9.0 database server from: openSUSE 11.4, kernel 2.6.37.6-24-default, Pg 9.0.13 to: openSUSE 13.1, kernel v 3.11.10-21-default, Pg 9.0.15 ... and overall server load is +1 after that. We did not add any new services/daemons. It's hard to track down to individual queries