Re: higth performance write to disk

From: Jeison Bedoya Delgado <jeisonb(at)audifarma(dot)com(dot)co>
To: pgsql-performance(at)postgresql(dot)org
Subject: Re: higth performance write to disk
Date: 2013-09-04 18:52:00
Message-ID: 52278150.9080501@audifarma.com.co
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-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(at)audifarma(dot)com(dot)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.

In response to

Responses

Browse pgsql-performance by date

  From Date Subject
Next Message Tomas Vondra 2013-09-04 19:19:43 Re: higth performance write to disk
Previous Message Jeff Janes 2013-09-04 16:29:13 Re: COPY TO and VACUUM