Thank you for the clarification. On Wed, Mar 15, 2023 at 1:42 PM Илья Шипицин <chipits...@gmail.com> wrote:
> 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. >> >