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

Thu, 06 May 2010 04:03:37 -0700 

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

Responder a