[PERFORM] long wait times in ProcessCatchupEvent()

;t seem to be an issue here. Regards, Julian v. Bock -- Julian v. Bock Projektleitung Software-Entwicklung OpenIT GmbH Tel +49 211 239 577-0 In der Steele 33a-41 Fax +49 211 239 577-10 D-40599 Düsseldorf http://www

Re: [PERFORM] long wait times in ProcessCatchupEvent()

Hi >>>>> "TL" == Tom Lane writes: TL> b...@openit.de (Julian v. Bock) writes: >> I have the problem that on our servers it happens regularly under a >> certain workload (several times per minute) that all backend >> processes get a SIGUSR1 and s

Re: [PERFORM] What is the most optimal config parameters to keep stable write TPS ?..

Hi > "D" == Dimitri writes: D> current postgresql.conf: D> # D> max_connections = 2000 # (change requires restart) D> temp_buffers = 200MB temp_buffers are kept per connection and not freed until the session ends. If you use some kind of connection pooling