Re: Queries becoming slow under heavy load

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



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


-- 
Sent via pgsql-performance mailing list (pgsql-performance@xxxxxxxxxxxxxx)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-performance



[Postgresql General]     [Postgresql PHP]     [PHP Users]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Yosemite]

  Powered by Linux