Hi, yeah i am sorry, i run the postgresql in a machine with this
configuration
Ram: 128GB
cpu: 32 cores
Disk: 400GB over SAN
The database run an application web over glassfish, and have 2.000 users
my database configuracion is this:
max_connections = 900
shared_buffers = 4096MB
temp_buffers = 128MB
work_mem = 1024MB
maintenance_work_mem = 1024MB
wal_buffers = 256
checkpoint_segments = 103
effective_cache_size = 4096MB
thanks
Atentamente,
JEISON BEDOYA DELGADO
Adm. Servidores y Comunicaciones
AUDIFARMA S.A.
El 08/07/2013 11:40 a.m., Andrew Dunstan escribió:
On 07/08/2013 12:22 PM, Jeison Bedoya wrote:
Hi, i want to know why in my database the process stay in BID, PARSE,
autentication, startup by a couple minuts, generating slow in the
process, perhaps tunning parameters? or configuration of operating
system (Linux RHEL 6).
You haven't given us nearly enough information about your setup. We'd
need to see your configuration settings and have some details of the
machine and where connections are coming from to diagnose it further.
cheers
andrew
--
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance
