Re: PostgreSQL: How can use slave for some read operations?

Thank you for the clarification. On Wed, Mar 15, 2023 at 1:42 PM Илья Шипицин 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 : > >> Hi, >> >> I have A

Re: PostgreSQL: How can use slave for some read operations?

what i have done is create frontends and backends for all of the load balanced nodes, and separate f/e and b/e for the individual nodes.  for instance: frontend mariadb     mode tcp     bind 192.168.120.3:3306     default_backend mariadb frontend mariadb1     mode tcp    

Re: PostgreSQL: How can use slave for some read operations?

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 : > Hi, > > I have A master and a slave PostgreSQL databases. I would like to know > that major read operations can be

PostgreSQL: How can use slave for some read operations?

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?