Re: [PERFORM] Perf decreased although server is better

2016-11-10 Thread Benjamin Toueg
be `trust` for both, now it's `md5` for both). Any help appreciated, Thanks 2016-11-04 15:05 GMT+01:00 Kevin Grittner : > On Fri, Nov 4, 2016 at 6:53 AM, Benjamin Toueg wrote: > > > I don't see how this can be due to network latency! > > I'm not suggesting it i

Re: [PERFORM] Perf decreased although server is better

2016-11-04 Thread Benjamin Toueg
er-is-better 2016-11-04 1:05 GMT+01:00 Kevin Grittner : > On Thu, Nov 3, 2016 at 9:51 AM, Benjamin Toueg wrote: > > > > Stream gives substantially better results with the new server > (before/after) > > Yep, the new server can access RAM at about twice the speed of the old. &g

Re: [PERFORM] Perf decreased although server is better

2016-11-03 Thread Benjamin Toueg
> > Do you have all of the kernel settings configured per best practices? > Sometimes it is easy to forget them when you get totally focused on just > moving the data. > (Things such as your hugepages settings) > > With 9.6 you can enable parallel queries. Of course you wouldn&#x

[PERFORM] Perf decreased although server is better

2016-11-02 Thread Benjamin Toueg
Hi everyone, I'm facing a peformance decrease after switching to a more performant VPS : http://serverfault.com/questions/812702/posgres-perf-decreased-although-server-is-better My questions are: 1. What benchmark should I perform before switching to a new server? 2. What's your rule of th