Perf decreased although server is better - Mailing list pgsql-performance

From Benjamin Toueg
Subject Perf decreased although server is better
Date
Msg-id CAK6K-L+JvBEk0wA7KgKDCm=ORFvOuiBgf2r7por=D+hkyCTW3g@mail.gmail.com
Whole thread Raw
Responses Re: Perf decreased although server is better  (Tomas Vondra <tomas.vondra@2ndquadrant.com>)
Re: Perf decreased although server is better  (Kevin Grittner <kgrittn@gmail.com>)
Re: Perf decreased although server is better  (Rick Otten <rottenwindfish@gmail.com>)
List pgsql-performance
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 thumb regarding my specific issue? What should be investigated first?

Best Regards,

Benjamin

pgsql-performance by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: Refresh materialized view vs recreate
Next
From: Tomas Vondra
Date:
Subject: Re: Perf decreased although server is better