there are several L7 balancing tool like pgPool. as for haproxy, currently it does not provide such advanced postgresql routing
ср, 15 мар. 2023 г. в 06:09, Muhammed Fahid <mfa...@posibolt.com>: > Hi, > > I have A master and a slave PostgreSQL databases. I would like to know > that major read operations can be processed with slave for reducing load in > master ?? > > for example : I have a large number of products.when customers want to > list all products. Is it possible to read from a slave database? instead of > from the master database ?. If major read operations are done in master its > slows down the other operations in master. >
