Message-ID: <52278150.9080501@audifarma.com.co>
Date: Wed, 04 Sep 2013 13:52:00 -0500
From: Jeison Bedoya Delgado <jeisonb@audifarma.com.co>
Organization: Audifarma S.A.
User-Agent: Mozilla/5.0 (Windows NT 6.1;
 rv:17.0) Gecko/20130801 Thunderbird/17.0.8
MIME-Version: 1.0
To: pgsql-performance@postgresql.org
Subject: Re: higth performance write to disk
References: <52275046.3040508@audifarma.com.co>
 <CAHyXU0waLKMVBEVamzv2T8jQ-FmJGYj-=7R4S5tCah-EiCvijw@mail.gmail.com>
In-Reply-To: 
 <CAHyXU0waLKMVBEVamzv2T8jQ-FmJGYj-=7R4S5tCah-EiCvijw@mail.gmail.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 8bit
Precedence: bulk
Sender: pgsql-performance-owner@postgresql.org

Hi merlin,
Thanks for your interest, I'm using version 9.2.2, I have a machine with 
128GB RAM, 32 cores, and my BD weighs 400GB. When I say slow I meant 
that while consultations take or failing a copy with pgdump, this taking 
the same time before had 10K disks in raid 10 and now that I have SSDs 
in Raid 10.

That behavior is normal, or you can improve writing and reading.

thank you very much
El 04/09/2013 10:27 a.m., Merlin Moncure escribió:
> On Wed, Sep 4, 2013 at 10:22 AM, Jeison Bedoya Delgado
> <jeisonb@audifarma.com.co> wrote:
>> Hello, in order to improve the performance of my database included in the
>> solution SAN SSD disk on RAID 10, but I see that the performance of the
>> database is the same. whichpostgresql.conf parameters that I do recommend to
>> change for use writing more.
> Going to need some more detailed information.  In particular,
> transaction rates, hardware specifics, database version, definition of
> 'slow', etc etc etc.
>
> merlin
>
>

-- 
Atentamente,


JEISON BEDOYA DELGADO
ADM.Servidores y comunicaciones
AUDIFARMA S.A.


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