[GENERAL] PgBouncer with many databases

Is it possible to use PgBouncer in this scenario: User comes to my WA, and opens new account. In that case I create a new database for that user. I noticed that in PgBouncer config file I have to set a database line, so I'm confused Is there any way to deal with this problem? Just to say it in

[GENERAL] Tunning postgresql.conf

Hi all, I have a server with 4 x Intel(R) Xeon(R) CPU E5640 @ 2.67GHz and * 12 GB* of memory. * There will be hosted ~100 databases with lot of reads and some writing. My postgresql.conf is:* listen_addresses = '*' max_connections = 300 shared_bu

[GENERAL] High CPU usage of stats collector

On my db server I have noticed a very high CPU usage of process: *postgres: stats collector process* It is not below 50% of CPU. (Info from htop). What is best way to decrease CPU usage of this process? Thanks -- View this message in context: http://postgresql.1045698.n5.nabble.com/High-CPU-

Re: [GENERAL] High CPU usage of stats collector

*288* -- View this message in context: http://postgresql.1045698.n5.nabble.com/High-CPU-usage-of-stats-collector-tp5750271p5750925.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes

Re: [GENERAL] High CPU usage of stats collector

yes. maybe ~200 databases -- View this message in context: http://postgresql.1045698.n5.nabble.com/High-CPU-usage-of-stats-collector-tp5750271p5750918.html Sent from the PostgreSQL - general mailing list archive at Nabble.com. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.