Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.84_2) (envelope-from ) id 1b5qs2-000857-7v for pgsql-performance@arkaria.postgresql.org; Thu, 26 May 2016 08:42:22 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.84_2) (envelope-from ) id 1b5qs1-00040V-Nk for pgsql-performance@arkaria.postgresql.org; Thu, 26 May 2016 08:42:21 +0000 Received: from magus.postgresql.org ([2a02:c0:301:0:ffff::29]) by malur.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA384:256) (Exim 4.84_2) (envelope-from ) id 1b5qs1-000403-1Y for pgsql-performance@postgresql.org; Thu, 26 May 2016 08:42:21 +0000 Received: from mail-lf0-x235.google.com ([2a00:1450:4010:c07::235]) by magus.postgresql.org with esmtps (TLS1.2:ECDHE_RSA_AES_256_CBC_SHA1:256) (Exim 4.84_2) (envelope-from ) id 1b5qrw-0006Px-M3 for pgsql-performance@postgresql.org; Thu, 26 May 2016 08:42:20 +0000 Received: by mail-lf0-x235.google.com with SMTP id b73so7082752lfb.3 for ; Thu, 26 May 2016 01:42:16 -0700 (PDT) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=leboutique.com; s=google; h=mime-version:in-reply-to:references:from:date:message-id:subject:to :cc; bh=ftK1KPBLhobRpdDEc3lKCr89gCx5VvcBb08855maBgM=; b=DuprdiasokyObFiKQYdVaIVkLKpH6wVH5k7nlGrSjz1DP1PYjqxrmnzKpjqSvqmi2Y SV3DJ++BE71TmCBTMUxH1lqeiN0wUi422G1H4hzoUYJExcyavCeRc9BGPumX+9F1LI3+ xfKeaYIIJo/D97F27gR3EBAiFI5FZVX9jnaGY= X-Google-DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=1e100.net; s=20130820; h=x-gm-message-state:mime-version:in-reply-to:references:from:date :message-id:subject:to:cc; bh=ftK1KPBLhobRpdDEc3lKCr89gCx5VvcBb08855maBgM=; b=jLZWATOYv4gUZL6vo6tVP+j13MSY/Osm0CnyWEyJxBDACbtFEtomfVYfwohzZpmHxk DMyCyhsYXio4Qj+24qs4pCjtrpK+BpBxawji2tYRqj1j1LjRiV43+byBsoz9ieO45rKK ec29NTt58LWjeeBIPxj7AMte4+9KZTpKkjUpsX1iFpRysSjLyVkke89GUkpSBa8L2i3L uBL+9LVsvZi6yfIN9A4bMbZY8R0nwtKoIyF0U2BDIcqqumO06K0ByIF/9iMWtnoAUVAU llFxyOYrYOn506WFYFIOI3R1WKKkKexJLubzCBTySDGSyPYi3V23Y8ckQdEZttVKR0E+ dB9A== X-Gm-Message-State: ALyK8tIQE0i7D2Z92ZoZdcoVyZ2tpa4++6gFFsnjxievFr9yBFMfyloBE7zie5rweWwHAb0Tc5+uGmFeP6vtBipK X-Received: by 10.25.17.105 with SMTP id g102mr2649458lfi.145.1464252135494; Thu, 26 May 2016 01:42:15 -0700 (PDT) MIME-Version: 1.0 Received: by 10.25.18.229 with HTTP; Thu, 26 May 2016 01:41:55 -0700 (PDT) In-Reply-To: References: From: Artem Tomyuk Date: Thu, 26 May 2016 11:41:55 +0300 Message-ID: Subject: Re: Testing in AWS, EBS To: Tory M Blue Cc: "pgsql-performance@postgresql.org" Content-Type: multipart/alternative; boundary=001a113fbbf865ea6d0533bac437 X-Pg-Spam-Score: -2.7 (--) List-Archive: List-Help: List-ID: List-Owner: List-Post: List-Subscribe: List-Unsubscribe: X-Mailing-List: pgsql-performance Precedence: bulk Sender: pgsql-performance-owner@postgresql.org --001a113fbbf865ea6d0533bac437 Content-Type: text/plain; charset=UTF-8 Hi. AWS EBS its a really painful story.... How was created volumes for RAID? From snapshots? If you want to get the best performance from EBS it needs to pre-warmed. Here is the tutorial how to achieve that: http://docs.aws.amazon.com/AWSEC2/latest/UserGuide/ebs-initialize.html Also you should read this one if you want to get really great for performance: http://hatim.eu/2014/05/24/leveraging-ssd-ephemeral-disks-in-ec2-part-1/ Good luck! 2016-05-26 1:34 GMT+03:00 Tory M Blue : > We are starting some testing in AWS, with EC2, EBS backed setups. > > What I found interesting today, was a single EBS 1TB volume, gave me > something like 108MB/s throughput, however a RAID10 (4 250GB EBS > volumes), gave me something like 31MB/s (test after test after test). > > I'm wondering what you folks are using inside of Amazon (not > interested in RDS at the moment). > > Thanks > Tory > > > -- > Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-performance > --001a113fbbf865ea6d0533bac437 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: quoted-printable
Hi.

AWS EBS its a really pai= nful story....
How was created volumes for RAID? From snapshots?=C2=A0=
If you want to get the best performance from EBS it needs to pre-warme= d.

Here is the tutorial how to achieve that:
=

Also you should read this one if = you want to get really great for performance:

=
2016-05-26 1:34 GMT+03:00 Tory M Blue <tmblue@g= mail.com>:
We are starting = some testing in AWS, with EC2, EBS backed setups.

What I found interesting today, was a single EBS 1TB volume, gave me
something like 108MB/s throughput, however a RAID10 (4 250GB EBS
volumes), gave me something like 31MB/s (test after test after test).

I'm wondering what you folks are using inside of Amazon (not
interested in RDS at the moment).

Thanks
Tory


--
Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-perform= ance

--001a113fbbf865ea6d0533bac437--