pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  
help / color / mirror / Atom feed
From: Gustavo Franklin Nóbrega - Planae <gfnobrega@planae.com.br>
To: Patrick Vedrines <patrick.vedrines@adpcl.com>
Cc: performance pgsql <pgsql-performance@postgresql.org>
Subject: Re: CPU 0.1% IOWAIT 99% for decisonnal queries
Date: Thu, 24 Mar 2005 08:52:15 -0300
Message-ID: <4242A9EF.7070005@planae.com.br> (raw)
In-Reply-To: <004d01c53054$965583e0$1e0baf96@pcpatrickxp>
References: <002601c52f0a$2312a4d0$280baf96@PCPATRICK>
	<424063BC.3050206@planae.com.br>
	<004d01c53054$965583e0$1e0baf96@pcpatrickxp>

Good day Patrick!
   
    I can help you to design you disk layout for better perform and 
security. Please, tell me how many disks (and some specs, like capacity 
and RPM).

    If you want to know more, there is a very interesting article abou 
benckmark filesystem ( http://linuxgazette.net/102/piszcz.html ). In 
this article, ReiserFS 3.6, JFS and XFS are in the same level at top 
depending your application, and ext3 is more slow than others. I believe 
that version 4 of the ReiserFS is better that version 3.6, but I could 
not still test it.

    Raid0 (striping, more at 
http://www.pcguide.com/ref/hdd/perf/raid/levels/singleLevel0-c.html) or 
Raid 0+1 (stripping + mirror, more at 
http://www.pcguide.com/ref/hdd/perf/raid/levels/multLevel01-c.html) is 
very insteresting to postgresql. Raid0 provides only performance, and 
Raid 0+1 provides performance and security. Take a look at this articles 
and think about to use Raid (http://www.pcguide.com/ref/hdd/perf/raid/).

    I'm glad to help. Best regards!

Atenciosamente,

Gustavo Franklin Nóbrega
Infraestrutura e Banco de Dados
Planae Tecnologia da Informação
(+55) 14 3106-3514
http://www.planae.com.br




Patrick Vedrines wrote:

> Hello Gustavo,
>  
> Your question seems to say that you suspect a disk issue, and a few 
> hours later, Simon told me "Sounds like your disks/layout/something is 
> pretty sick".
> To be clear in my own mind about it, I've just copyed (time cp) the 
> "aggregate" table files (4 Gb) from one disk to an another one: it 
> takes 22 mn !(3 Mb/s).
> That seems to demonstrate that Postgres is not the cause of this issue.
> I've just untrusted to my system engineer the analysis of my disks...
>  
> In case I would have to change my disks, do you have any performance 
> figures related to the types you mentionned (reiserfs vs ext3) ?
> I don't use RAID since the security is not a concern.
>  
> Thank a lot for your help !
>  
> Patrick
>
>      
>     Hi Patrick,
>
>         How is configured your disk array? Do you have a Perc 4?
>
>     Tip: Use reiserfs instead ext3, raid 0+1 and deadline I/O
>     scheduler in kernel linux 2.6
>
> 
>

view thread (11+ messages)  latest in thread

Message-ID: <4242A9EF.7070005@planae.com.br>
Permalink:  ../4242A9EF.7070005@planae.com.br/
Also on:    postgresql.org/message-id/4242A9EF.7070005@planae.com.br

 · 

reply

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: gfnobrega@planae.com.br, patrick.vedrines@adpcl.com
  Subject: Re: CPU 0.1% IOWAIT 99% for decisonnal queries
  In-Reply-To: <4242A9EF.7070005@planae.com.br>

* 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