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 <[EMAIL PROTECTED]> Para: "[EMAIL PROTECTED]" <[EMAIL PROTECTED]> 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, [EMAIL PROTECTED] <[EMAIL PROTECTED]> 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/
dmesg
Description: Binary data
---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org