Re: [GENERAL] Optimal checkpoint_setting

2014-10-14 Thread pinker
Thank you for your answer, but I don't have access to this server any more and have to just interpret and pick some parameters from test results, but your advice about tar trick is something I'm gonna try for sure in next test. So, because I don't have any chance to do some more tests, should I ch

Re: [GENERAL] Optimal checkpoint_setting

2014-10-09 Thread Kevin Grittner
John R Pierce wrote: > On 10/9/2014 1:13 PM, Dennis wrote: >> Hi, a little off the general topic but I am just wondering if the “tar >> -cf - pgdata | wc -c” trick can be used as general trick to pre-warm >> the cache? > > I wouldn't do this if your pgdata is larger than about 50% of your > physi

Re: [GENERAL] Optimal checkpoint_setting

2014-10-09 Thread John R Pierce
On 10/9/2014 1:13 PM, Dennis wrote: Hi, a little off the general topic but I am just wondering if the “tar -cf - pgdata | wc -c” trick can be used as general trick to pre-warm the cache? I wouldn't do this if your pgdata is larger than about 50% of your physical ram. -- john r pierce

Re: [GENERAL] Optimal checkpoint_setting

2014-10-09 Thread Dennis
Hi, a little off the general topic but I am just wondering if the “tar -cf - pgdata | wc -c” trick can be used as general trick to pre-warm the cache? Thanks. On Oct 9, 2014, at 10:55 AM, Jeff Janes wrote: > On Thu, Oct 9, 2014 at 3:52 AM, pinker wrote: > Hello All, > I have a brand new machi

Re: [GENERAL] Optimal checkpoint_setting

2014-10-09 Thread Jeff Janes
On Thu, Oct 9, 2014 at 3:52 AM, pinker wrote: > Hello All, > I have a brand new machine to tune: > x3750 M4, 4xE5-4640v2 2.2GHz; 512GBRAM (32x16GB), 4x300GB > SAS + SSD (Easy Tier) in RAID 10 > > What's particularly important now is to choose optimal configuration for > write operations. We have

[GENERAL] Optimal checkpoint_setting

2014-10-09 Thread pinker
Hello All, I have a brand new machine to tune: x3750 M4, 4xE5-4640v2 2.2GHz; 512GBRAM (32x16GB), 4x300GB SAS + SSD (Easy Tier) in RAID 10 What's particularly important now is to choose optimal configuration for write operations. We have discussion about checkpoint_segments and checkpoint_timeout p