Re: [pgbr-geral] Re s: Re: PROBLEMAS DE PERFORMANCE

Thu, 06 May 2010 05:51:28 -0700 

Mais de 8GB de RAM.

Em vez de ter 2 servidores de 38 GB cada porque não 8 com 10GB de ram cada.

Antes de dizer que fica mais caro, não fica porque vc vai dimensionar o que
precisa em cada maquina e não precisa pagar licença de VM.

Fiz um orçamento com a dell, e os servidores virtualizados ficaram 20% mais
caro.

Preferi ficar com 8 maquinas de 32GB de RAM cada fico bem mais barato.


andrecf wrote:
> 
> Mais de 8Gb de RAM ou de disco?
> Enviado através do meu BlackBerry® da Nextel
> 
> -----Original Message-----
> From: mateusgra <[email protected]>
> Date: Wed, 5 May 2010 20:52:47 
> To: <[email protected]>
> Subject: Re: [pgbr-geral] PROBLEMAS DE PERFORMANCE
> 
> 
> Maquinas virtuais tem degradaçao de performance com mais de 8GB.
> 
> Vc pode confirmar isso com desenvolvedores do VmWare.
> 
> VM no maximo com 8GB.
> 
> 
> 
> Wolak Sistemas - Fabiano Machado Dias wrote:
>> 
>> 
>> 
>> 
>>   
>> 
>> 
>> Boa tarde, 
>> 
>> Concordo com o Telles, rodar um banco de dados em um ambiente
>> virtualizado n&atilde;o &eacute; uma boa id&eacute;ia a n&atilde;o ser
>> para fins de testes e olhe
>> l&aacute;! 
>> 
>> Recomendo que voc&ecirc; leia atentamente esse artigo [1] e configure
>> melhor
>> o seu postgresql.conf 
>> 
>> Neste outro link [2] voc&ecirc; pode colocar o valor em GB que ele te
>> d&aacute; o
>> valor correto em bytes. 
>> 
>> Para o valor de shmmax voc&ecirc; pode utilizar o valor calculado pelo
>> site,
>> e para o shmall pegue o mesmo valor (ou o que voc&ecirc; quer
>> especificar)
>> e
>> divida por 4096. 
>> 
>> Por exemplo: 
>> 
>> 6 GB = 6442450944 bytes 
>> 6442450944 / 4096 = 1572864 
>> 
>> ent&atilde;o 
>> 
>> 
>> kernel.shmmax = 6442450944 
>> kernel.shmall = 1572864 
>> 
>> shared_buffers deve ser igual ou menor que o valor de kernel.shmmax 
>> 
>> N&atilde;o lembro se na 8.1 os valores j&aacute; s&atilde;o em MB, mas de
>> qualquer forma
>> atualize a sua vers&atilde;o para a 8.4 
>> 
>> Outras coisas que voc&ecirc; pode alterar de cara s&atilde;o esses: 
>> 
>> work_mem - Cuidado com valores grandes, leia o artigo que voc&ecirc; vai
>> enteder 
>> max_stack_depth - utilize o "ulimit - s" e veja o valor retonado,
>> fa&ccedil;a
>> testes mas nunca ultrapasse o valor 
>> vaccum_cost_delay - habilite por&eacute;m o valor vai depender bastante
>> da
>> aplica&ccedil;&atilde;o 
>> commit_delay - idem&nbsp; vaccum_cost_delay 
>> random_page_cost = 2 
>> 
>> 
>> [1] -
>> http://www.pgcon.org/2008/schedule/attachments/44_annotated_gucs_draft1.pdf 
>> [2] - http://www.easycalculation.com/bandwidth-calculator.php 
>> 
>> Abra&ccedil;&atilde;o, 
>> Fabiano Machado Dias 
>> 
>> 
>> sebastiao fidencio escreveu:
>> 
>>   Pessoal Bom dia, estou enviando esse email, porquanto estou com
>> s&eacute;rio problemas de performance eu meu banco de dados. Segue meu
>> cen&aacute;rio: 
>>   &nbsp; 
>>   servidores fisicos 
>>   &nbsp; 
>>   2 servidores&nbsp;- DLG 160&nbsp; com 38 GB de ram cada um, trabalhando
>> em
>> cluster.. (hd dos servidres e de 146GB)&nbsp; - cada m&aacute;quina
>> fisica
>> tem 2
>> CPU quad..da intel 
>>   storage com 8 discos de 400 gb, trabalhando em raid.&nbsp; 
>>   &nbsp; 
>>   &nbsp; 
>>   Sistema operacional instalado nos Servidores fisicos: VMWARE
>> ENTERPRISE ESX&nbsp; 4.0 
>>   &nbsp; 
>>   &nbsp; 
>>   Tenho umas 13 m&aacute;quinas virtuais criadas entre windows e linux,
>> Entretanto o servidor de banco de dados(maquina virtual)&nbsp;que de fato
>> &eacute;
>> o postgresql 8.1.3 com a seguinte configura&ccedil;&atilde;o: 
>>   &nbsp; 
>>   6&nbsp; (cpu's) 
>>   16GB de ram 
>>   150GB na parti&ccedil;&atilde;o /dados onde est&aacute; montado o
>> cluster do banco de
>> dados de produ&ccedil;&atilde;o. 
>>   10 GB&nbsp; onde est&aacute; instalado a distribui&ccedil;&atilde;o
>> SUSE
>> Linux Enterprise
>> 11 64bits 
>>   &nbsp; 
>>   &nbsp; 
>>   &nbsp; 
>>   Problema: 
>>   &nbsp; 
>>   &nbsp; 
>>   Acontece que, pessoal come&ccedil;a usar o sistema pela parte da
>> manh&atilde;,
>> e por volta de 10:00hrs da manh&atilde;o o ERP come&ccedil;a a ficar
>> bastante lento
>> at&eacute; chegar o ponto de travar, e percebo que quanto mais recurso
>> disponibilizo para o servidor de sgbd, mais ele consome, poxa..na tem
>> hardware que de conta disso. as consultas, a CPu e memoria vai para o
>> ultimo estagio, e toda vez tem q ficar reiniciando o sgbd, j&aacute;
>> segui
>> alguns conselhos para realizar tunnig no sgbd, mas n&atilde;o deu
>> certo..,
>> gostaria da opini&atilde;o de voc&ecirc;s o que eu tenho que fazer para
>> resolver
>> esse problema. 
>>   &nbsp; 
>>   segue o link para voc&ecirc;s verem minhas conf's 
>>   &nbsp; 
>>   postgresql.conf 
>>   http://200.175.138.130/postgresql.conf 
>>   &nbsp; 
>>   &nbsp; 
>>   System V: (configura&ccedil;&atilde;o defaul que veio, eu nem mexi em
>> nada) 
>>   &nbsp; 
>>   kernel.shmmax = 18446744073709551615 
>> kernel.shmall = 1152921504606846720 
>> kernel.shmmni = 4096 
>>   
>>   &nbsp; 
>>   &nbsp; 
>>   &nbsp; 
>>   &nbsp; 
>>   estado da maquina agora sem problemas: (porem a qualquer momento
>> ela pode apresenta problemas, principalmente quando os usuarios racam
>> relatorios pesados).. 
>>   &nbsp; 
>>   a rede hoje tem cerca de 150 usuarios ativos no sistema. 
>>   &nbsp; 
>>   &nbsp; 
>>   &nbsp; 
>>   uso de memoria 
>>  
>> =============================================================================
>>  
>>   dberp:/dados/pgsql # cat /proc/meminfo 
>> MemTotal:&nbsp;&nbsp;&nbsp;&nbsp; 16307396 kB 
>> MemFree:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1711440 kB 
>> Buffers:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 23724 kB 
>> Cached:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4221676 kB 
>> SwapCached:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 80676 kB 
>> Active:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 4742244 kB 
>> Inactive:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1533132 kB 
>> SwapTotal:&nbsp;&nbsp;&nbsp;&nbsp; 1044216 kB 
>> SwapFree:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 592144 kB 
>> Dirty:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
>> 1012 kB 
>> Writeback:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0
>> kB 
>> AnonPages:&nbsp;&nbsp;&nbsp;&nbsp; 1954908 kB 
>> Mapped:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 1075736 kB 
>> Slab:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
>> 70516 kB 
>> SReclaimable:&nbsp;&nbsp;&nbsp; 34456 kB 
>> SUnreclaim:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 36060 kB 
>> PageTables:&nbsp;&nbsp;&nbsp;&nbsp; 201260 kB 
>> NFS_Unstable:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 kB 
>> Bounce:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
>> 0 kB 
>> WritebackTmp:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 kB 
>> CommitLimit:&nbsp;&nbsp; 9197912 kB 
>> Committed_AS:&nbsp; 3784748 kB 
>> VmallocTotal: 34359738367 kB 
>> VmallocUsed:&nbsp;&nbsp;&nbsp; 306132 kB 
>> VmallocChunk: 34359431799 kB 
>> HugePages_Total:&nbsp;&nbsp;&nbsp;&nbsp; 0 
>> HugePages_Free:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 
>> HugePages_Rsvd:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 
>> HugePages_Surp:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 0 
>> Hugepagesize:&nbsp;&nbsp;&nbsp;&nbsp; 2048 kB 
>> DirectMap4k:&nbsp;&nbsp;&nbsp;&nbsp; 10240 kB 
>> DirectMap2M:&nbsp; 16766976 kB 
>> dberp:/dados/pgsql # 
>> ==========================================================================================================================
>>  
>>   &nbsp; 
>>   &nbsp; 
>>   &nbsp; 
>>   &nbsp; 
>>   cpu 
>>   =================================================================== 
>>   top - 11:55:46 up 21:26,&nbsp; 2 users,&nbsp; load average: 0.71, 0.40,
>> 2.34 
>> Tasks: 197 total,&nbsp;&nbsp; 1 running, 194 sleeping,&nbsp;&nbsp; 2
>> stopped,&nbsp;&nbsp; 0 zombie 
>> Cpu0&nbsp; :&nbsp; 2.2%us,&nbsp; 0.8%sy,&nbsp; 0.0%ni, 95.8%id,&nbsp;
>> 1.3%wa,&nbsp; 0.0%hi,&nbsp; 0.0%si,&nbsp;
>> 0.0%st 
>> Cpu1&nbsp; : 14.8%us,&nbsp; 1.7%sy,&nbsp; 0.0%ni, 71.9%id, 11.3%wa,&nbsp;
>> 0.0%hi,&nbsp; 0.1%si,&nbsp;
>> 0.0%st 
>> Cpu2&nbsp; :&nbsp; 1.5%us,&nbsp; 0.8%sy,&nbsp; 0.0%ni, 97.2%id,&nbsp;
>> 0.6%wa,&nbsp; 0.0%hi,&nbsp; 0.0%si,&nbsp;
>> 0.0%st 
>> Cpu3&nbsp; :&nbsp; 0.3%us,&nbsp; 0.7%sy,&nbsp; 0.0%ni, 98.6%id,&nbsp;
>> 0.3%wa,&nbsp; 0.0%hi,&nbsp; 0.0%si,&nbsp;
>> 0.0%st 
>> Cpu4&nbsp; :&nbsp; 0.2%us,&nbsp; 0.7%sy,&nbsp; 0.0%ni, 98.9%id,&nbsp;
>> 0.2%wa,&nbsp; 0.0%hi,&nbsp; 0.0%si,&nbsp;
>> 0.0%st 
>> Cpu5&nbsp; :&nbsp; 0.2%us,&nbsp; 0.6%sy,&nbsp; 0.0%ni, 99.1%id,&nbsp;
>> 0.1%wa,&nbsp; 0.0%hi,&nbsp; 0.0%si,&nbsp;
>> 0.0%st 
>> Mem:&nbsp; 16307396k total, 14723100k used,&nbsp; 1584296k
>> free,&nbsp;&nbsp;&nbsp; 24536k buffers 
>> Swap:&nbsp; 1044216k total,&nbsp;&nbsp; 451616k used,&nbsp;&nbsp; 592600k
>> free,&nbsp; 4371700k cached 
>>   &nbsp; PID USER&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; PR&nbsp; NI&nbsp;
>> VIRT&nbsp; RES&nbsp; SHR S %CPU %MEM&nbsp;&nbsp;&nbsp; TIME+&nbsp;
>> COMMAND 
>> 11807 postgres&nbsp; 20&nbsp;&nbsp; 0 1108m 303m 296m D&nbsp;&nbsp;&nbsp;
>> 5&nbsp; 1.9&nbsp;&nbsp; 1:02.66 postmaster 
>> &nbsp;&nbsp;&nbsp; 1 root&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 20&nbsp;&nbsp;
>> 0&nbsp; 1064&nbsp;&nbsp; 76&nbsp;&nbsp; 32 S&nbsp;&nbsp;&nbsp; 0&nbsp;
>> 0.0&nbsp;&nbsp; 0:15.54 init 
>> &nbsp;&nbsp;&nbsp; 2 root&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15&nbsp;
>> -5&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0
>> S&nbsp;&nbsp;&nbsp; 0&nbsp; 0.0&nbsp;&nbsp; 0:00.02 kthreadd 
>> &nbsp;&nbsp;&nbsp; 3 root&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; RT&nbsp;
>> -5&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0
>> S&nbsp;&nbsp;&nbsp; 0&nbsp; 0.0&nbsp;&nbsp; 0:00.04 migration/0 
>> &nbsp;&nbsp;&nbsp; 4 root&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15&nbsp;
>> -5&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0
>> S&nbsp;&nbsp;&nbsp; 0&nbsp; 0.0&nbsp;&nbsp; 0:00.18 ksoftirqd/0 
>> &nbsp;&nbsp;&nbsp; 5 root&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; RT&nbsp;
>> -5&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0
>> S&nbsp;&nbsp;&nbsp; 0&nbsp; 0.0&nbsp;&nbsp; 0:00.02 migration/1 
>> &nbsp;&nbsp;&nbsp; 6 root&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15&nbsp;
>> -5&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0
>> S&nbsp;&nbsp;&nbsp; 0&nbsp; 0.0&nbsp;&nbsp; 0:00.06 ksoftirqd/1 
>> &nbsp;&nbsp;&nbsp; 7 root&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; RT&nbsp;
>> -5&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0
>> S&nbsp;&nbsp;&nbsp; 0&nbsp; 0.0&nbsp;&nbsp; 0:00.00 migration/2 
>> &nbsp;&nbsp;&nbsp; 8 root&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15&nbsp;
>> -5&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0
>> S&nbsp;&nbsp;&nbsp; 0&nbsp; 0.0&nbsp;&nbsp; 0:00.02 ksoftirqd/2 
>> &nbsp;&nbsp;&nbsp; 9 root&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; RT&nbsp;
>> -5&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0
>> S&nbsp;&nbsp;&nbsp; 0&nbsp; 0.0&nbsp;&nbsp; 0:00.00 migration/3 
>> &nbsp;&nbsp; 10 root&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15&nbsp;
>> -5&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0
>> S&nbsp;&nbsp;&nbsp; 0&nbsp; 0.0&nbsp;&nbsp; 0:00.00 ksoftirqd/3 
>> &nbsp;&nbsp; 11 root&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; RT&nbsp;
>> -5&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0
>> S&nbsp;&nbsp;&nbsp; 0&nbsp; 0.0&nbsp;&nbsp; 0:00.02 migration/4 
>> &nbsp;&nbsp; 12 root&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15&nbsp;
>> -5&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0
>> S&nbsp;&nbsp;&nbsp; 0&nbsp; 0.0&nbsp;&nbsp; 0:00.00 ksoftirqd/4 
>> &nbsp;&nbsp; 13 root&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; RT&nbsp;
>> -5&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0
>> S&nbsp;&nbsp;&nbsp; 0&nbsp; 0.0&nbsp;&nbsp; 0:00.00 migration/5 
>> &nbsp;&nbsp; 14 root&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15&nbsp;
>> -5&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0
>> S&nbsp;&nbsp;&nbsp; 0&nbsp; 0.0&nbsp;&nbsp; 0:00.00 ksoftirqd/5 
>> &nbsp;&nbsp; 15 root&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15&nbsp;
>> -5&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0
>> S&nbsp;&nbsp;&nbsp; 0&nbsp; 0.0&nbsp;&nbsp; 0:01.58 events/0 
>> &nbsp;&nbsp; 16 root&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15&nbsp;
>> -5&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0
>> S&nbsp;&nbsp;&nbsp; 0&nbsp; 0.0&nbsp;&nbsp; 0:01.62 events/1 
>> &nbsp;&nbsp; 17 root&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15&nbsp;
>> -5&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0
>> S&nbsp;&nbsp;&nbsp; 0&nbsp; 0.0&nbsp;&nbsp; 0:01.52 events/2 
>> &nbsp;&nbsp; 18 root&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15&nbsp;
>> -5&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0
>> S&nbsp;&nbsp;&nbsp; 0&nbsp; 0.0&nbsp;&nbsp; 0:02.16 events/3 
>> &nbsp;&nbsp; 19 root&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15&nbsp;
>> -5&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0
>> S&nbsp;&nbsp;&nbsp; 0&nbsp; 0.0&nbsp;&nbsp; 0:02.06 events/4 
>> &nbsp;&nbsp; 20 root&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15&nbsp;
>> -5&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0
>> S&nbsp;&nbsp;&nbsp; 0&nbsp; 0.0&nbsp;&nbsp; 0:02.74 events/5 
>> &nbsp;&nbsp; 21 root&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15&nbsp;
>> -5&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0
>> S&nbsp;&nbsp;&nbsp; 0&nbsp; 0.0&nbsp;&nbsp; 0:00.00 khelper 
>> &nbsp;&nbsp; 22 root&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15&nbsp;
>> -5&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0
>> S&nbsp;&nbsp;&nbsp; 0&nbsp; 0.0&nbsp;&nbsp; 0:00.00
>> kintegrityd/0 
>> &nbsp;&nbsp; 23 root&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15&nbsp;
>> -5&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0
>> S&nbsp;&nbsp;&nbsp; 0&nbsp; 0.0&nbsp;&nbsp; 0:00.00
>> kintegrityd/1 
>> &nbsp;&nbsp; 24 root&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15&nbsp;
>> -5&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0
>> S&nbsp;&nbsp;&nbsp; 0&nbsp; 0.0&nbsp;&nbsp; 0:00.00
>> kintegrityd/2 
>> &nbsp;&nbsp; 25 root&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15&nbsp;
>> -5&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0
>> S&nbsp;&nbsp;&nbsp; 0&nbsp; 0.0&nbsp;&nbsp; 0:00.00
>> kintegrityd/3 
>> &nbsp;&nbsp; 26 root&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15&nbsp;
>> -5&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0
>> S&nbsp;&nbsp;&nbsp; 0&nbsp; 0.0&nbsp;&nbsp; 0:00.00
>> kintegrityd/4 
>> &nbsp;&nbsp; 27 root&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15&nbsp;
>> -5&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0
>> S&nbsp;&nbsp;&nbsp; 0&nbsp; 0.0&nbsp;&nbsp; 0:00.00
>> kintegrityd/5 
>> &nbsp;&nbsp; 28 root&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15&nbsp;
>> -5&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0
>> S&nbsp;&nbsp;&nbsp; 0&nbsp; 0.0&nbsp;&nbsp; 0:00.04 kblockd/0 
>> &nbsp;&nbsp; 29 root&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15&nbsp;
>> -5&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0
>> S&nbsp;&nbsp;&nbsp; 0&nbsp; 0.0&nbsp;&nbsp; 0:04.58 kblockd/1 
>> &nbsp;&nbsp; 30 root&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15&nbsp;
>> -5&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0
>> S&nbsp;&nbsp;&nbsp; 0&nbsp; 0.0&nbsp;&nbsp; 0:00.06 kblockd/2 
>> &nbsp;&nbsp; 31 root&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15&nbsp;
>> -5&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0
>> S&nbsp;&nbsp;&nbsp; 0&nbsp; 0.0&nbsp;&nbsp; 0:00.02 kblockd/3 
>> &nbsp;&nbsp; 32 root&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; 15&nbsp;
>> -5&nbsp;&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0&nbsp;&nbsp;&nbsp; 0
>> S&nbsp;&nbsp;&nbsp; 0&nbsp; 0.0&nbsp;&nbsp; 0:00.02 kblockd/4 
>> ============================================================ 
>>   &nbsp; 
>>   &nbsp; 
>>   &nbsp; 
>>   &nbsp; 
>>   &nbsp; 
>>   Ficarei grato por isso! 
>>   &nbsp; 
>>   
>> 
>>_______________________________________________
>> pgbr-geral mailing list
>> [email protected] 
>> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral 
>>   
>> 
>> 
>> 
>> 
>> 
>>_______________________________________________
>> pgbr-geral mailing list
>> [email protected]
>> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
>> 
>> 
> 
> -- 
> View this message in context:
> http://old.nabble.com/PROBLEMAS-DE-PERFORMANCE-tp28462191p28469041.html
> Sent from the PostgreSQL - Brasil mailing list archive at Nabble.com.
> 
> _______________________________________________
> pgbr-geral mailing list
> [email protected]
> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
> _______________________________________________
> pgbr-geral mailing list
> [email protected]
> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
> 
> 

-- 
View this message in context: 
http://old.nabble.com/PROBLEMAS-DE-PERFORMANCE-tp28462191p28473152.html
Sent from the PostgreSQL - Brasil mailing list archive at Nabble.com.

_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral

Responder a