From: brauagustin-susc@yahoo.com.ar
To: pgsql-performance@postgresql.org
Subject: Re: Low CPU Usage
Date: Wed, 19 Sep 2007 12:52:43 -0700 (PDT)
Message-ID: <27902.18461.qm@web30003.mail.mud.yahoo.com> (raw)
This is my dmesg file, I see there are some errors but I don't know how to manage!!!
What do you mean with don't top post?
Sorry but I'm new with this kind of mailing list and I don't want to botter some others.
Sorry my bad English too.
Thanks for your help
----- Mensaje original ----
De: Scott Marlowe <scott.marlowe@gmail.com>
Para: "brauagustin-susc@yahoo.com.ar" <brauagustin-susc@yahoo.com.ar>
CC: pgsql-performance@postgresql.org
Enviado: miércoles 19 de septiembre de 2007, 16:41:45
Asunto: Re: [PERFORM] Low CPU Usage
On 9/19/07, brauagustin-susc@yahoo.com.ar <brauagustin-susc@yahoo.com.ar> wrote:
>
>
> No, changing to fsync off didn't improve performance at all.
>
> Settings
> work_mem = 64MB
> max_stack_depth = 7MB #in the old server is 8MB but if I set in here give me
> the ulimit error
> max_fsm_pages = 204800
> effective_cache_size = 512MB
> Atuvacuum is off.
>
> I have run vacuum full and vacuum analyze. The databases are freezed (there
> are no insert, update or delete operations)!!!
> In both servers the query plans are identical with the same costs too!!!
>
> It's really weird, I don't see high values monitoring disk. Cpu usage is
> about 5% and sometimes a tips of 40 % of disk usage when the query is
> finishing (the first 3 minutes there are some tips of 11 to 16%).
(please don't top post)
This sounds like you've got problems somewhere in your I/O system.
hdparm etc may or may not be seeing the issue. What do you see in
/var/log/messages or dmesg?
Los referentes más importantes en compra/ venta de autos se juntaron:
Demotores y Yahoo!
Ahora comprar o vender tu auto es más fácil. Vistá ar.autos.yahoo.com/
Attachments:
dmesg (application/octet-stream, 14.2K) download
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: brauagustin-susc@yahoo.com.ar
Subject: Re: Low CPU Usage
In-Reply-To: <27902.18461.qm@web30003.mail.mud.yahoo.com>
* 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