Received: from malur.postgresql.org ([217.196.149.56]) by arkaria.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TiVEg-0000D6-M1 for pgsql-performance@arkaria.postgresql.org; Tue, 11 Dec 2012 19:11:22 +0000 Received: from localhost ([127.0.0.1] helo=postgresql.org) by malur.postgresql.org with smtp (Exim 4.72) (envelope-from ) id 1TiVEf-0005ak-Nz for pgsql-performance@arkaria.postgresql.org; Tue, 11 Dec 2012 19:11:21 +0000 Received: from makus.postgresql.org ([98.129.198.125]) by malur.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TiVEe-0005af-Lo for pgsql-performance@postgresql.org; Tue, 11 Dec 2012 19:11:20 +0000 Received: from mail-la0-f46.google.com ([209.85.215.46]) by makus.postgresql.org with esmtp (Exim 4.72) (envelope-from ) id 1TiVEc-00055t-F2 for pgsql-performance@postgresql.org; Tue, 11 Dec 2012 19:11:19 +0000 Received: by mail-la0-f46.google.com with SMTP id p5so3172505lag.19 for ; Tue, 11 Dec 2012 11:11:16 -0800 (PST) DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=20120113; h=content-type:mime-version:subject:from:in-reply-to:date:cc :message-id:references:to:x-mailer; bh=h5B52LI8KcahD4mA5RIXHRbbpC2R4HjjN5q7nRU5q1s=; b=JdItKUjXJjaNq4Vl+HO0RB466VdI8PB/heinrYVNOZ1XCI/q6+tBGUXjZjL5E74o67 lM+uCy3CbdaRJVGjDTcJ0Tj+l2lP1V5vipoeNiPrKUVr8yZih5Nn+u+Byg2z1UrkFg76 vBbcQ18RLHKQ/BhnjMHDF0A4s7zdwl2LEb7B4oSEHvgh3Z30ai/ii8/jOclfOdZmUHMT zv2Jubl7bxyaVXq+Ht5qWdCQrniZ9qNKgml1X0nVMnI3TEsilyA3ZOMY0puyjUVr+Uf3 CoFU8ce1KGsNGqgL8l1LOnZREWPRuCIla6kheMOjURL+8wSqpRTHyX2n58HrzsofiPOM WiRg== Received: by 10.112.99.195 with SMTP id es3mr8021678lbb.132.1355253076676; Tue, 11 Dec 2012 11:11:16 -0800 (PST) Received: from [192.168.20.5] ([176.195.39.85]) by mx.google.com with ESMTPS id fe4sm3682949lbb.1.2012.12.11.11.11.14 (version=TLSv1/SSLv3 cipher=OTHER); Tue, 11 Dec 2012 11:11:15 -0800 (PST) Content-Type: multipart/alternative; boundary="Apple-Mail=_B1F749F4-6B08-4562-A35D-790FDC5A25CB" Mime-Version: 1.0 (Mac OS X Mail 6.2 \(1499\)) Subject: Re: Do I have a hardware or a software problem? From: Evgeny Shishkin In-Reply-To: Date: Tue, 11 Dec 2012 23:11:14 +0400 Cc: "pgsql-performance@postgresql.org" , Jeff Janes , Craig Ringer Message-Id: References: <8F7661E7-D6D4-4334-8C6A-A8B6C56A2C3F@autouncle.com> <50C7351C.30407@2ndQuadrant.com> <4507A68A-3CD5-4283-AFA5-1C0593427E14@autouncle.com> <67FBF3AF-5C6A-45D4-9206-7257C8C01C5E@gmail.com> To: =?iso-8859-1?Q?Niels_Kristian_Schj=F8dt?= X-Mailer: Apple Mail (2.1499) X-Pg-Spam-Score: -2.6 (--) 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 --Apple-Mail=_B1F749F4-6B08-4562-A35D-790FDC5A25CB Content-Transfer-Encoding: quoted-printable Content-Type: text/plain; charset=windows-1252 On Dec 11, 2012, at 10:54 PM, Niels Kristian Schj=F8dt = wrote: > And what is your experience so far? >=20 Increased tps by a factor of 10, database no longer a limiting factor of = application. And it is cheaper than brand rotating drives. > Den 11/12/2012 18.16 skrev "Evgeny Shishkin" : >=20 > On Dec 11, 2012, at 5:35 PM, Niels Kristian Schj=F8dt = wrote: >=20 > > > > Den 11/12/2012 kl. 14.29 skrev Craig Ringer : > > > >> On 12/11/2012 06:04 PM, Niels Kristian Schj=F8dt wrote: > >>> > >>> Maybe I should mention, that I never see more than max 5Gb out of = my total 32Gb being in use on the server=85 Can I somehow utilize more = of it? > >> For an update-mostly workload it probably won't do you tons of good = so > >> long as all your indexes fit in RAM. You're clearly severely > >> bottlenecked on disk I/O not RAM. > >>> The SSD's I use a are 240Gb each which will grow too small within = a > >>> few months - so - how does moving the whole data dir onto four of > >>> those in a RAID5 array sound? > >> > >> Not RAID 5! > >> > >> Use a RAID10 of four or six SSDs. > >> > >> -- > >> Craig Ringer http://www.2ndQuadrant.com/ > >> PostgreSQL Development, 24x7 Support, Training & Services > >> > > Hehe got it - did you have a look at the SSD's I am considering = building it of? = http://ark.intel.com/products/66250/Intel-SSD-520-Series-240GB-2_5in-SATA-= 6Gbs-25nm-MLC > > Are they suitable do you think? > > >=20 > I am not Craig, but i use them in production in raid10 array now. >=20 > > > > > > -- > > Sent via pgsql-performance mailing list = (pgsql-performance@postgresql.org) > > To make changes to your subscription: > > http://www.postgresql.org/mailpref/pgsql-performance >=20 --Apple-Mail=_B1F749F4-6B08-4562-A35D-790FDC5A25CB Content-Transfer-Encoding: quoted-printable Content-Type: text/html; charset=windows-1252 nielskristian@autouncle.com> wrote:

And what is your experience so = far?

Increased tps by a factor of 10, database no = longer a limiting factor of application.
And it is cheaper = than brand rotating drives.


Den 11/12/2012 18.16 skrev "Evgeny Shishkin" = <itparanoia@gmail.com>:

On Dec 11, 2012, at 5:35 PM, Niels Kristian Schj=F8dt <nielskristian@autouncle.com> wrote:

>
> Den 11/12/2012 kl. 14.29 skrev Craig Ringer <craig@2ndQuadrant.com>:
>
>> On 12/11/2012 06:04 PM, Niels Kristian Schj=F8dt wrote:
>>>
>>> Maybe I should mention, that I never see more than max 5Gb = out of my total 32Gb being in use on the server=85 Can I somehow utilize = more of it?
>> For an update-mostly workload it probably won't do you tons of = good so
>> long as all your indexes fit in RAM. You're clearly = severely
>> bottlenecked on disk I/O not RAM.
>>> The SSD's I use a are 240Gb each which will grow too small = within a
>>> few months - so - how does moving the whole data dir onto = four of
>>> those in a RAID5 array sound?
>>
>> Not RAID 5!
>>
>> Use a RAID10 of four or six SSDs.
>>
>> --
>> Craig Ringer               =     http://www.2ndQuadrant.com/
>> PostgreSQL Development, 24x7 Support, Training & = Services
>>
> Hehe got it - did you have a look at the SSD's I am considering = building it of? http://ark.intel.com/products/66250/Intel-SSD-520-Series= -240GB-2_5in-SATA-6Gbs-25nm-MLC
> Are they suitable do you think?
>

I am not Craig, but i use them in production in raid10 array now.

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


= --Apple-Mail=_B1F749F4-6B08-4562-A35D-790FDC5A25CB--