From: jmcdonagh <Joseph.E.McDonagh@gmail.com>
To: pgsql-performance@postgresql.org
Subject: Re: Incredibly slow restore times after 9.0>9.2 upgrade
Date: Wed, 29 Oct 2014 09:33:01 -0700 (PDT)
Message-ID: <1414600380999-5824871.post@n5.nabble.com> (raw)
In-Reply-To: <CABAbqycsWF6PusE4jsh-qUB-ABb8wGDPj9Sc22D8vuFpOokKyA@mail.gmail.com>
References: <1414529739004-5824701.post@n5.nabble.com>
<5450084E.1060808@fuzzy.cz>
<1414595543866-5824847.post@n5.nabble.com>
<CABAbqycsWF6PusE4jsh-qUB-ABb8wGDPj9Sc22D8vuFpOokKyA@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
Hi Jason, oddly enough the setting on or off does not affect this particular
issue. As a rule I generally enable this option on my instances that support
it. I recently tried upping the nodes to the latest generation (m3) to try
and rectify/improve this issue. Unfortunately right now m3 won't work
because we rely on a lot of space in mnt for temporary data work and the new
instances don't have much space there (though it is much faster). So I went
back to m1.large and left EBS optimized off. I'm not seeing any note-worthy
change in performance.
So I went and fired up an RDS postgres instance here. Eventually I want to
move to RDS anyways, but it's not a good short term solution to the right
now issue. Restore is running now, so I'll know within the next day or so if
this is much faster.
I'm puzzled by the change from 9.0 to 9.2 coinciding with this though.
Before the upgrade this job never had any issues. But I am 100% aware that
could be a red herring.
--
View this message in context: http://postgresql.1045698.n5.nabble.com/Incredibly-slow-restore-times-after-9-0-9-2-upgrade-tp582470...
Sent from the PostgreSQL - performance mailing list archive at Nabble.com.
--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: Joseph.E.McDonagh@gmail.com
Subject: Re: Incredibly slow restore times after 9.0>9.2 upgrade
In-Reply-To: <1414600380999-5824871.post@n5.nabble.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox