Re: [PERFORM] Perf decreased although server is better

Hi, I tried pg_repack on the new server with no luck, so I've decided to move back to the old server to discard: 1. performance decrease due to server raw characteristics 2. performance decrease due to network latencies I've seen no improvement whatsoever. Could the issue be due to one

Re: [PERFORM] Perf decreased although server is better

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 is due to network latency -- it is due to the latency for storage requests. That won't depend on network latency unless you are going to a LAN for

Re: [PERFORM] Perf decreased although server is better

> Rick, what did you mean by kernel configuration? The OS is a standard Ubuntu 16.04: > > - Linux 4.4.0-45-generic #66-Ubuntu SMP Wed Oct 19 14:12:37 UTC 2016 x86_64 x86_64 x86_64 GNU/Linux > > Do you think losing half the number of cores can explain my performance issue ? (AMD 8 cores down to

Re: [PERFORM] Perf decreased although server is better

My guess would be that your server upgrade wasn't the upgrade you thought it was. You network latency could definitely be the cause of most of this. The problem is you're not measuring this from the server side. It's not only going to impact connect time, but you're going to get your data a bit

Re: [PERFORM] Perf decreased although server is better

I've noticed a network latency increase. Ping between web server and database : 0.6 ms avg before, 5.3 ms avg after -- it wasn't that big 4 days ago :( I've narrowed my investigation to one particular "Transaction" in terms of the NewRelic APM. It's basically the main HTTP request of my

Re: [PERFORM] Perf decreased although server is better

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. > I've run "bonnie++ -u postgres -d /tmp/ -s 4096M -r 1096" on both >

Re: [PERFORM] Perf decreased although server is better

Stream gives substantially better results with the new server (before /after ) I've run "bonnie++ -u postgres -d /tmp/ -s 4096M -r 1096" on both machines. I don't know how to read bonnie++ results (before

Re: [PERFORM] Perf decreased although server is better

How did you migrate from one system to the other? [ I recently moved a large time series table from 9.5.4 to 9.6.1 using dump and restore. Although it put the BRIN index on the time column back on, it was borked. Reindexing didn't help. I had to switch it to a regular btree index. I think the

Re: [PERFORM] Perf decreased although server is better

On Wed, Nov 2, 2016 at 8:26 AM, Benjamin Toueg wrote: > I'm facing a peformance decrease after switching to a more performant VPS : In my world, the VPS that performs worse is not considered "more performant", no matter what the sales materials say. > What benchmark should I

Re: [PERFORM] Perf decreased although server is better

On 11/02/2016 02:26 PM, Benjamin Toueg wrote: 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 Well, changing so many things at once (CPU, RAM, storage, Ubuntu

[PERFORM] Perf decreased although server is better

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