From: Ing. Marcos Ortiz Valmaseda <mlortiz@uci.cu>
To: Anne Rosset <arosset@collab.net>
Cc: pgsql-performance@postgresql.org
Subject: Re: Queries becoming slow under heavy load
Date: Tue, 25 Jan 2011 17:27:01 -0500 (CST)
Message-ID: <51831170.52414881295994420979.JavaMail.root@ucimail4.uci.cu> (raw)
In-Reply-To: <1482241980.52411061295994101582.JavaMail.root@ucimail4.uci.cu>
When you say that with a lot of concurrent access, queries get very slow, How many concurrent connections to your server have you had?
more that max_connections´value?
If you want to have many concurrent connections, you should have consider to use a pooling connection system like pgbouncer or pgpool.
Which are the values for:
- work_mem
- shared_buffers
- maintenance_work_mem
- effective_cache_size
- effective_io_concurrency
- server_version
Which are your platform?
Regards
--
Ing. Marcos Luís Ortíz Valmaseda
System Engineer -- Database Administrator
Centro de Tecnologías de Gestión de Datos (DATEC)
Universidad de las Ciencias Informáticas
http://postgresql.uci.cu
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-performance@postgresql.org
Cc: mlortiz@uci.cu, arosset@collab.net
Subject: Re: Queries becoming slow under heavy load
In-Reply-To: <51831170.52414881295994420979.JavaMail.root@ucimail4.uci.cu>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox