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
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@xxxxxxxxx>
Para: "brauagustin-susc@xxxxxxxxxxxx" <brauagustin-susc@xxxxxxxxxxxx>
CC: pgsql-performance@xxxxxxxxxxxxxx
Enviado: miércoles 19 de septiembre de 2007, 16:41:45
Asunto: Re: [PERFORM] Low CPU Usage
De: Scott Marlowe <scott.marlowe@xxxxxxxxx>
Para: "brauagustin-susc@xxxxxxxxxxxx" <brauagustin-susc@xxxxxxxxxxxx>
CC: pgsql-performance@xxxxxxxxxxxxxx
Enviado: miércoles 19 de septiembre de 2007, 16:41:45
Asunto: Re: [PERFORM] Low CPU Usage
On 9/19/07, brauagustin-susc@xxxxxxxxxxxx
<brauagustin-susc@xxxxxxxxxxxx> 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?
>
>
> 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?
Seguí de cerca a la Selección Argentina de Rugby
en el Mundial de Francia 2007.
http://ar.sports.yahoo.com/mundialderugby
Attachment:
dmesg
Description: Binary data
---------------------------(end of broadcast)---------------------------
TIP 4: Have you searched our list archives?
http://archives.postgresql.org
