pg.ddx.io  pgsql-performance@postgresql.org mailing list archive  

help / color / mirror / Atom feed

From: André Volpato <andre.volpato@ecomtecnologia.com.br>
To: pgsql-performance@postgresql.org
Subject: Postgres not using array
Date: Wed, 20 Aug 2008 15:30:25 -0300
Message-ID: <48AC62C1.9070209@ecomtecnologia.com.br> (raw)

Folks,

In a fresh Pg8.3.3 box, we created a 3-stripe RAID0 array.
The write speed is about 180MB/s, as shown by dd :

# dd if=/dev/zero of=/postgres/base/teste2 bs=1024 count=5000000
5000000+0 records in
5000000+0 records out
5120000000 bytes (5,1 GB) copied, 28,035 seconds, 183 MB/s

BTW, /postgres is $PGDATA ...

Unfortunely, we cant figure out why Postgres is not using the disks at all.
Right now, there are 3 heavy queryes running, and the disks are almost 
sleeping...
The CPU is 100% used since a few hours ago. Can anyone tell why?

# dstat
----total-cpu-usage---- -dsk/total- -net/total- ---paging-- ---system--
usr sys idl wai hiq siq|_read _writ|_recv _send|__in_ _out_|_int_ _csw_
 99   1   0   0   0   0|   0     0 | 574B 1710B|   0     0 |   6    55
 99   1   0   0   0   0|   0     0 | 290B  770B|   0     0 |   8    48
 99   1   0   0   0   0|   0     0 | 220B  540B|   0     0 |   6    44
 99   1   0   0   0   0|   0     0 | 354B  818B|   0     0 |  10    50
 98   2   0   0   0   0|   0     0 |1894B 4857B|   0     0 |  27    78
100   0   0   0   0   1|   0     0 | 348B 1096B|   0     0 |  12    45

The specs:
Intel(R) Pentium(R) Dual  CPU  E2160  @ 1.80GHz
Linux dbserver4 2.6.24-etchnhalf.1-686-bigmem #1 SMP Mon Jul 21 11:59:12 
UTC 2008 i686 GNU/Linux
4GB RAM

-- 

[]´s, ACV

view thread (12+ messages)  latest in thread

Message-ID: <48AC62C1.9070209@ecomtecnologia.com.br>
Permalink:  ../48AC62C1.9070209@ecomtecnologia.com.br/
Also on:    postgresql.org/message-id/48AC62C1.9070209@ecomtecnologia.com.br

copy link · copy postgr.es

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: andre.volpato@ecomtecnologia.com.br
  Subject: Re: Postgres not using array
  In-Reply-To: <48AC62C1.9070209@ecomtecnologia.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