From: Jeison Bedoya Delgado <jeisonb@audifarma.com.co>
To: pgsql-performance@postgresql.org
Subject: Re: higth performance write to disk
Date: Wed, 04 Sep 2013 13:52:00 -0500
Message-ID: <52278150.9080501@audifarma.com.co> (raw)
In-Reply-To: <CAHyXU0waLKMVBEVamzv2T8jQ-FmJGYj-=7R4S5tCah-EiCvijw@mail.gmail.com>
References: <52275046.3040508@audifarma.com.co>
<CAHyXU0waLKMVBEVamzv2T8jQ-FmJGYj-=7R4S5tCah-EiCvijw@mail.gmail.com>
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-performance>
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
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: jeisonb@audifarma.com.co
Subject: Re: higth performance write to disk
In-Reply-To: <52278150.9080501@audifarma.com.co>
* 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