Existem conexões IDLE de um mesmo usuário. Isso pode significar que as
conexões com o banco não estão sendo fechadas, e isso impede futuras
conexões...
Tudo bem que tenha somente 60 usuários, mas se cada um se conectar 2
ou 3 vezes, logo logo ninguém mais poderá fazê-lo...
2008/9/16 Brasil Software <[EMAIL PROTECTED]>
> Segue em anexo a estatísticas do banco de dados.
>
> max_connections = 100
> shared_buffers = 32MB work_mem = 1MB
>
> Tenho 50 no máximo 60 usuários conectados.
>
> Máquina :HP
> Processado :XEON 1.80 Hz
> Memoria :1GB
> HD :70GB espelhado "SCSI"
> Banco :3 base uma com 3 GB outras 4 GB e a ultima 2 um total 9 GB
> de BD.
>
>
> Um detalhe importante é que sempre tenho que reiniciar o servidor as 22:00
> horas para voltar a funcionar.
>
> 38605 banco002 3844 58718 002_norma <IDLE> in
> transaction f 2008-09-16 10:38:39.093-03 2008-09-16
> 08:13:40.64-03 10.0.0.20 1045
> 38605 banco002 676 58699 002_normede <IDLE> in
> transaction f 2008-09-16 10:50:24.25-03 2008-09-16
> 07:56:45.625-03 10.0.0.188 1106
> 38605 banco002 3108 58706 002_edvan <IDLE> in
> transaction f 2008-09-16 10:52:45.968-03 2008-09-16
> 07:52:31.812-03 10.0.0.185 1080
> 29669 banco001 3056 58698 001_roberval <IDLE> in
> transaction f 2008-09-16 10:11:21.828-03 2008-09-16
> 07:52:28.515-03 10.0.0.28 1064
> 29669 banco001 2160 58714 001_rosecobranca <IDLE> in
> transaction f 2008-09-16 09:38:06.75-03 2008-09-16
> 09:37:33.937-03 10.0.0.201 1643
> 38605 banco002 3248 58697 002_roberval <IDLE> in
> transaction f 2008-09-16 10:45:56.546-03 2008-09-16
> 07:52:41.39-03 10.0.0.28 1076
> 38605 banco002 3272 58689 002_edson <IDLE> in
> transaction f 2008-09-16 10:55:00.171-03 2008-09-16
> 07:57:37.765-03 10.0.0.41 1086
> 38605 banco002 148 58697 002_roberval <IDLE> in
> transaction f 2008-09-16 10:50:09.812-03 2008-09-16
> 07:52:53.578-03 10.0.0.28 1091
> 29669 banco001 2008 58691 001_edsonluiz <IDLE> in
> transaction f 2008-09-16 10:50:02.343-03 2008-09-16
> 07:57:05.578-03 10.0.0.41 1083
> 38605 banco002 2752 58706 002_edvan <IDLE> in
> transaction f 2008-09-16 10:52:48.156-03 2008-09-16
> 07:57:01.765-03 10.0.0.185 1106
> 38605 banco002 2920 58689 002_edson <IDLE> in
> transaction f 2008-09-16 10:50:39.156-03 2008-09-16
> 07:57:13.531-03 10.10.1.211 1090
> 38605 banco002 944 58687 002_raphael <IDLE> in
> transaction f 2008-09-16 10:45:32.39-03 2008-09-16
> 08:13:51.171-03 10.0.0.193 1085
> 38605 banco002 1992 58696 002_nivia <IDLE> in
> transaction f 2008-09-16 10:40:59.078-03 2008-09-16
> 08:12:10.218-03 10.0.0.186 1182
> 29669 banco001 3680 58691 001_edsonluiz <IDLE> in
> transaction f 2008-09-16 10:37:58.39-03 2008-09-16
> 07:58:35.171-03 10.10.1.211 1133
> 38605 banco002 3812 58689 002_edson <IDLE> in
> transaction f 2008-09-16 07:59:07.953-03 2008-09-16
> 07:59:07.859-03 10.10.1.211 1142
> 38605 banco002 2836 58751 002_juscelino <IDLE> in
> transaction f 2008-09-16 10:49:38.234-03 2008-09-16
> 08:00:20.546-03 10.10.1.107 1063
> 38605 banco002 1660 58684 002_tais <IDLE> in
> transaction f 2008-09-16 10:48:01.437-03 2008-09-16
> 08:01:54.187-03 10.0.0.44 1090
> 38605 banco002 3480 58693 002_gustavo <IDLE> in
> transaction f 2008-09-16 10:22:02.046-03 2008-09-16 08:01:52-03
> 10.0.0.195 1080
> 38605 banco002 2332 58690 002_rose <IDLE> in
> transaction f 2008-09-16 10:54:15.375-03 2008-09-16
> 08:00:04.656-03 10.0.0.201 1070
> 38605 banco002 3620 58716 002_janusa <IDLE> in
> transaction f 2008-09-16 10:32:16.515-03 2008-09-16
> 09:58:04.781-03 10.10.1.35 1993
> 38605 banco002 3372 58706 002_edvan <IDLE> in
> transaction f 2008-09-16 10:45:01.484-03 2008-09-16
> 08:25:44.171-03 10.10.1.249 2290
> 38605 banco002 1884 58690 002_rose <IDLE> in
> transaction f 2008-09-16 10:43:37.203-03 2008-09-16
> 08:00:39.578-03 10.0.0.201 1094
> 38605 banco002 3892 58683 002_henrique <IDLE> in
> transaction f 2008-09-16 10:53:38.343-03 2008-09-16
> 08:02:54.843-03 10.0.0.47 1078
> 38605 banco002 2900 58683 002_henrique <IDLE> in
> transaction f 2008-09-16 08:04:20.781-03 2008-09-16
> 08:04:20.718-03 10.0.0.47 1088
> 38605 banco002 4056 58705 002_jeane <IDLE> in
> transaction f 2008-09-16 10:48:19.578-03 2008-09-16
> 08:09:04.375-03 10.0.0.12 1097
> 38605 banco002 4080 58692 002_lay <IDLE> in transaction f
> 2008-09-16 10:54:44.609-03 2008-09-16 10:51:48.546-03
> 10.0.0.136 1820
> 38605 banco002 3908 58681 002_milena <IDLE> in
> transaction f 2008-09-16 10:51:32.281-03 2008-09-16
> 08:08:46.328-03 10.0.0.44 1161
> 38605 banco002 1132 58693 002_gustavo <IDLE> in
> transaction f 2008-09-16 10:52:21.609-03 2008-09-16
> 08:09:40.781-03 10.0.0.195 1335
> 38605 banco002 1648 58694 002_sandra <IDLE> in
> transaction f 2008-09-16 10:54:54.093-03 2008-09-16
> 08:12:45.328-03 10.10.1.26 1363
> 38605 banco002 3044 58687 002_raphael <IDLE> in
> transaction f 2008-09-16 10:54:34.875-03 2008-09-16
> 08:14:06.953-03 10.0.0.193 1094
> 29669 banco001 2028 58709 001_janusa <IDLE> in
> transaction f 2008-09-16 09:59:36.718-03 2008-09-16
> 09:59:28.984-03 10.10.1.35 2017
> 38605 banco002 3828 59085 002_patricia <IDLE> in
> transaction f 2008-09-16 10:54:35.125-03 2008-09-16
> 10:54:01.859-03 10.0.0.79 1320
> 38605 banco002 3364 58701 002_carmen <IDLE> in
> transaction f 2008-09-16 09:01:03.125-03 2008-09-16
> 09:00:30.046-03 10.0.0.53 2068
> 38605 banco002 3592 58700 002_janine <IDLE> in
> transaction f 2008-09-16 10:51:43.39-03 2008-09-16
> 10:17:58.468-03 10.0.0.102 1115
> 38605 banco002 1156 58700 002_janine <IDLE> in
> transaction f 2008-09-16 10:52:58.312-03 2008-09-16
> 10:15:07.093-03 10.0.0.102 1066
> 38605 banco002 3008 58808 002_severo <IDLE> in
> transaction f 2008-09-16 10:21:35.609-03 2008-09-16
> 10:21:03.187-03 10.0.0.219 1187
> 29669 banco001 740 58710 001_janine <IDLE> in
> transaction f 2008-09-16 10:54:50.812-03 2008-09-16
> 10:54:15.171-03 10.0.0.102 1545
> 10819 postgres 3472 10 acesse <IDLE> f 2008-09-16
> 10:48:04.125-03 2008-09-16 10:47:58.765-03 127.0.0.1 3842
> 38605 banco002 2456 10 acesse <IDLE> in transaction f
> 2008-09-16 10:48:44.75-03 2008-09-16 10:48:44.171-03
> 10.10.1.11 49271
> 38605 banco002 2420 10 acesse <IDLE> f 2008-09-16
> 10:48:04.015-03 2008-09-16 10:48:03.906-03 127.0.0.1 3843
> 38605 banco002 1812 10 acesse copy (select * from
> pg_stat_activity) to 'E:\\\\act.txt' f 2008-09-16
> 10:55:00.187-03 2008-09-16 10:48:05.312-03 127.0.0.1 3844
> 38605 banco002 928 58703 002_dirceu <IDLE> in
> transaction f 2008-09-16 10:54:38.89-03 2008-09-16
> 10:51:21.953-03 10.10.1.246 1048
>
> _______________________________________________
> pgbr-geral mailing list
> [email protected]
> https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
>
>
--
William Leite Araújo
Analista de Banco de Dados - QualiConsult
_______________________________________________
pgbr-geral mailing list
[email protected]
https://listas.postgresql.org.br/cgi-bin/mailman/listinfo/pgbr-geral
