Our database (postgres) perfroming quite poorly at the moment, and we want reduce the load.
Anyone have any experience in setting up pg_pool ? How do you set it up ? and does it improve performance ?
Is it troublesome to mantain ?
[quote]Our database (postgres) perfroming quite poorly at the moment, and we want reduce the load.
Anyone have any experience in setting up pg_pool ? How do you set it up ? and does it improve performance ?
Is it troublesome to mantain ?[/quote]
It may need tuning for your site profile.
I have heard that some Matrix customers use it, but we had big problems with it causing site lockups. We use pg_bouncer instead.
Matrix 3.20.2 has persistent connections, which may be useful instead of pg_pool/bouncer as it is apache processes (I think) which hold the connection open for their life.
[quote]Our database (postgres) perfroming quite poorly at the moment, and we want reduce the load.
Anyone have any experience in setting up pg_pool ? How do you set it up ? and does it improve performance ?
Is it troublesome to mantain ?[/quote]
It is unlikely to make a substantial difference for most issues.
Have you configured postgres settings to match your setup? Which postgres and Matrix versions are you using? Are you running regular vacuum processes? Have you looked at the queries that are slow?
[quote]It is unlikely to make a substantial difference for most issues.
Have you configured postgres settings to match your setup? Which postgres and Matrix versions are you using? Are you running regular vacuum processes? Have you looked at the queries that are slow?[/quote]
We have suiz support doing the config & performance test for us, and yes they setup regular vacuum & automatic vacuum.
We are using postgres 8.1 , matrix 3.16.8.
Yes we had a look at the queries that are slow and we optimize one query that hogging the CPU the most.
I gues thats just one query and there might be other query that are not optimized.