Re: Queries becoming slow under heavy load

From: Ing. Marcos Ortiz Valmaseda
Subject: Re: Queries becoming slow under heavy load
Date: ,
Msg-id: 51831170.52414881295994420979.JavaMail.root@ucimail4.uci.cu
(view: Whole thread, Raw)
In response to: Queries becoming slow under heavy load  ("Anne Rosset")
List: pgsql-performance

Tree view

Queries becoming slow under heavy load  ("Anne Rosset", )
 Re: Queries becoming slow under heavy load  (Andy Colson, )
 Re: Queries becoming slow under heavy load  ("Kevin Grittner", )
 Re: Queries becoming slow under heavy load  ("Ing. Marcos Ortiz Valmaseda", )
 Re: Queries becoming slow under heavy load  (Ivan Voras, )
  Re: Queries becoming slow under heavy load  ("mark", )
 FW: Queries becoming slow under heavy load  ("Anne Rosset", )
  Re: FW: Queries becoming slow under heavy load  (Shaun Thomas, )
   Re: FW: Queries becoming slow under heavy load  (Scott Marlowe, )
  Re: FW: Queries becoming slow under heavy load  (Scott Marlowe, )
   Re: FW: Queries becoming slow under heavy load  ("Anne Rosset", )
    Re: FW: Queries becoming slow under heavy load  (Shaun Thomas, )
     Re: FW: Queries becoming slow under heavy load  (Mladen Gogala, )
     Re: FW: Queries becoming slow under heavy load  ("Anne Rosset", )
      Re: FW: Queries becoming slow under heavy load  (Scott Marlowe, )

When you say that with a lot of concurrent access, queries get very slow, How many concurrent connections to your
serverhave 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
pgbounceror 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



pgsql-performance by date:

From: Bruce Momjian
Date:
Subject: Re: Running PostgreSQL as fast as possible no matter the consequences
From: Ivan Voras
Date:
Subject: Re: Queries becoming slow under heavy load