Re: [pgsql-es-ayuda] postgresql.conf
Hola Maria Antonieta buenas tardes Dudo mucho que el problema sea postgres Primero ve que el problema no se trate desde tu aplicacion web asegurate que este cerrando la transacción y que este cerrando la conexion cuando tu script termine de ejecutarse. Para ver que procesos te estan generando el problema estos links pueden ayudarte https://wiki.duraspace.org/display/DSPACE/Idle+In+Transaction+Problem http://pg-promotor.blogspot.pe/2010/02/postgres-idle-in-transaction.html Respecto de tu archivo de configuracion parece que no has tocado nada y esta todo por defecto aqui tienes una guia rapida para configurar algunos valores https://wiki.postgresql.org/wiki/Mejorando_el_rendimiento_de_tu_Postgresql_Server saludos 2016-08-09 14:30 GMT-05:00 Maria Antonieta Ramirez < marami...@ulsaneza.edu.mx>: > Buena tarde > > > por medio del presente agradezco su tiempo y su atencion, tengo dudas > acerca de mi archivo de configuracion, mi servidor es windows server > enterprice service pack 1 y tiene 6GB de ram. > > > la aplicacion que se conecta a el tiene problea y llena la memoria virtual > de su servidor de aplicaciones, en la tabla de bloqueos me muestra unas > consultas que quedan en "idle in transaction" > > > revisando mi configuracion.. > > tengo lo siguiente en los siguientes parametros quisiera orientacion > acerca de que si la configuracion de estos parametros es correcta en > proporcion a mi servidor que es de 6GB DE RAM. ojala puedan apoyarme. > gracias!! > > > nota: mi base de datos contiene informacion que se consulta en linea para > fin educativo en maestrias y cursos. > > mi base pesa 313MB > > > Sin mas por el momento quedo en espera de sus comentarios y muchas gracias > por su apoyo!! > > > > > #--- > --- > # FILE LOCATIONS > #--- > --- > > # The default values of these variables are driven from the -D command-line > # option or PGDATA environment variable, represented here as ConfigDir. > > #data_directory = 'ConfigDir' # use data in another directory > # (change requires restart) > #hba_file = 'ConfigDir/pg_hba.conf' # host-based authentication file > # (change requires restart) > #ident_file = 'ConfigDir/pg_ident.conf' # ident configuration file > # (change requires restart) > > # If external_pid_file is not explicitly set, no extra PID file is written. > #external_pid_file = '' # write an extra PID file > # (change requires restart) > > > #--- > --- > # CONNECTIONS AND AUTHENTICATION > #--- > --- > > # - Connection Settings - > > listen_addresses = '*' # what IP address(es) to listen on; > # comma-separated list of addresses; > # defaults to 'localhost'; use '*' for all > # (change requires restart) > port = 5432 # (change requires restart) > max_connections = 100 # (change requires restart) > # Note: Increasing max_connections costs ~400 bytes of shared memory per > # connection slot, plus lock space (see max_locks_per_transaction). > #superuser_reserved_connections = 3 # (change requires restart) > #unix_socket_directories = '' # comma-separated list of directories > # (change requires restart) > #unix_socket_group = '' # (change requires restart) > #unix_socket_permissions = 0777 # begin with 0 to use octal notation > # (change requires restart) > #bonjour = off # advertise server via Bonjour > # (change requires restart) > #bonjour_name = '' # defaults to the computer name > # (change requires restart) > > # - Security and Authentication - > > #authentication_timeout = 1min # 1s-600s > #ssl = off # (change requires restart) > #ssl_ciphers = 'HIGH:MEDIUM:+3DES:!aNULL' # allowed SSL ciphers > # (change requires restart) > #ssl_prefer_server_ciphers = on # (change requires restart) > #ssl_ecdh_curve = 'prime256v1' # (change requires restart) > #ssl_renegotiation_limit = 512MB # amount of data between renegotiations > #ssl_cert_file = 'server.crt' # (change requires restart) > #ssl_key_file = 'server.key' # (change requires restart) > #ssl_ca_file = '' # (change requires restart) > #ssl_crl_file = '' # (change requires restart) > #password_encryption = on > #db_user_namespace = off > > # GSSAPI using Kerberos > #krb_server_keyfile = '' > #krb_caseins_users = off > > # - TCP Keepalives - > # see "man 7 tcp" for details > > #tcp_keepalives_idle = 0 # TCP_KEEPIDLE, in seconds; > # 0 selects the system default > #tcp_keepalives_interval = 0 # TCP_KEEPINTVL, in seconds; > # 0 selects the system default > #tcp_keepalives_count = 0 # TCP_KEEPCNT; > # 0 selects the system default > > > #--- > --- > # RESOURCE USAGE (except WAL) > #--- > --- > > # - Memory - > >
Re: [pgsql-es-ayuda] postgresql.conf
> > > > por medio del presente agradezco su tiempo y su atencion, tengo dudas > acerca de mi archivo de configuracion, mi servidor es windows server > enterprice service pack 1 y tiene 6GB de ram. > > la aplicacion que se conecta a el tiene problea y llena la memoria > virtual de su servidor de aplicaciones, en la tabla de bloqueos me > muestra unas consultas que quedan en "idle in transaction" > > Entonces primero tenes que revisar ese servidor de apps, y buscar ahi pistas de por que se queda sin memoria. Gerardo - Enviado a la lista de correo pgsql-es-ayuda (pgsql-es-ayuda@postgresql.org) Para cambiar tu suscripci�n: http://www.postgresql.org/mailpref/pgsql-es-ayuda
[pgsql-es-ayuda] postgresql.conf
Buena tarde por medio del presente agradezco su tiempo y su atencion, tengo dudas acerca de mi archivo de configuracion, mi servidor es windows server enterprice service pack 1 y tiene 6GB de ram. la aplicacion que se conecta a el tiene problea y llena la memoria virtual de su servidor de aplicaciones, en la tabla de bloqueos me muestra unas consultas que quedan en "idle in transaction" revisando mi configuracion.. tengo lo siguiente en los siguientes parametros quisiera orientacion acerca de que si la configuracion de estos parametros es correcta en proporcion a mi servidor que es de 6GB DE RAM. ojala puedan apoyarme. gracias!! nota: mi base de datos contiene informacion que se consulta en linea para fin educativo en maestrias y cursos. mi base pesa 313MB Sin mas por el momento quedo en espera de sus comentarios y muchas gracias por su apoyo!! #-- # FILE LOCATIONS #-- # The default values of these variables are driven from the -D command-line # option or PGDATA environment variable, represented here as ConfigDir. #data_directory = 'ConfigDir' # use data in another directory # (change requires restart) #hba_file = 'ConfigDir/pg_hba.conf' # host-based authentication file # (change requires restart) #ident_file = 'ConfigDir/pg_ident.conf' # ident configuration file # (change requires restart) # If external_pid_file is not explicitly set, no extra PID file is written. #external_pid_file = '' # write an extra PID file # (change requires restart) #-- # CONNECTIONS AND AUTHENTICATION #-- # - Connection Settings - listen_addresses = '*' # what IP address(es) to listen on; # comma-separated list of addresses; # defaults to 'localhost'; use '*' for all # (change requires restart) port = 5432 # (change requires restart) max_connections = 100 # (change requires restart) # Note: Increasing max_connections costs ~400 bytes of shared memory per # connection slot, plus lock space (see max_locks_per_transaction). #superuser_reserved_connections = 3 # (change requires restart) #unix_socket_directories = '' # comma-separated list of directories # (change requires restart) #unix_socket_group = '' # (change requires restart) #unix_socket_permissions = 0777 # begin with 0 to use octal notation # (change requires restart) #bonjour = off # advertise server via Bonjour # (change requires restart) #bonjour_name = '' # defaults to the computer name # (change requires restart) # - Security and Authentication - #authentication_timeout = 1min # 1s-600s #ssl = off # (change requires restart) #ssl_ciphers = 'HIGH:MEDIUM:+3DES:!aNULL' # allowed SSL ciphers # (change requires restart) #ssl_prefer_server_ciphers = on # (change requires restart) #ssl_ecdh_curve = 'prime256v1' # (change requires restart) #ssl_renegotiation_limit = 512MB # amount of data between renegotiations #ssl_cert_file = 'server.crt' # (change requires restart) #ssl_key_file = 'server.key' # (change requires restart) #ssl_ca_file = '' # (change requires restart) #ssl_crl_file = '' # (change requires restart) #password_encryption = on #db_user_namespace = off # GSSAPI using Kerberos #krb_server_keyfile = '' #krb_caseins_users = off # - TCP Keepalives - # see "man 7 tcp" for details #tcp_keepalives_idle = 0 # TCP_KEEPIDLE, in seconds; # 0 selects the system default #tcp_keepalives_interval = 0 # TCP_KEEPINTVL, in seconds; # 0 selects the system default #tcp_keepalives_count = 0 # TCP_KEEPCNT; # 0 selects the system default #-- # RESOURCE USAGE (except WAL) #-- # - Memory - shared_buffers = 128MB # min 128kB # (change requires restart) #huge_pages = try # on, off, or try # (change requires restart) #temp_buffers = 8MB # min 800kB #max_prepared_transactions = 0 # zero disables the feature # (change requires restart) # Note: Increasing max_prepared_transactions costs ~600 bytes of shared memory # per transaction slot, plus lock space (see max_locks_per_transaction). # It is not advisable to set max_prepared_transactions nonzero unless you # actively intend to use prepared transactions. #work_mem = 4MB # min 64kB #maintenance_work_mem = 64MB # min 1MB #autovacuum_work_mem = -1 # min 1MB, or -1 to use maintenance_work_mem #max_stack_depth = 2MB # min 100kB dynamic_shared_memory_type = windows # the default is the first option # supported by the operating system: # posix # sysv # windows # mmap # use none to disable dynamic shared memory # - Disk - #temp_file_limit = -1 # limits per-session temp file space # in kB, or -1 for no limit # - Kernel Resource Usage -
