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
