tag:blogger.com,1999:blog-3802120172110116696.post160048166679420370..comments2024-03-20T20:48:05.732+09:00Comments on Playing with PostgreSQL and Pgpool: Statement level load balancingTatsuo Ishiihttp://www.blogger.com/profile/02856952136007425773noreply@blogger.comBlogger13125tag:blogger.com,1999:blog-3802120172110116696.post-7593209045224698162021-09-02T22:15:04.511+09:002021-09-02T22:15:04.511+09:00Thank you very much for your support. It helps me ...Thank you very much for your support. It helps me to take decision on ReadWrite/ReadOnly DB's load balancing.Anonymoushttps://www.blogger.com/profile/00860584309981423591noreply@blogger.comtag:blogger.com,1999:blog-3802120172110116696.post-15089621831765337182021-09-02T11:20:43.884+09:002021-09-02T11:20:43.884+09:00If a function includes any writes (update, delete ...If a function includes any writes (update, delete or insert), this should be marked as "volatile" (https://www.postgresql.org/docs/13/xfunc-volatility.html).<br />If pgpool finds a volatile function in an SQL statement, pgpool will redirect the whole SQL statement to primary node.<br />i.e. pgpool will not redirect each statement in a function to both primary and standby.Tatsuo Ishiihttps://www.blogger.com/profile/02856952136007425773noreply@blogger.comtag:blogger.com,1999:blog-3802120172110116696.post-22235841975511240412021-09-01T21:34:08.211+09:002021-09-01T21:34:08.211+09:00Hi,
If Client calls one PostgreSQL Function whic...Hi, <br /><br />If Client calls one PostgreSQL Function which contains both select and update statements, In this case Select will redirect to Read-only Database node and update statements will redirect to Read Write Database node? Kindly help on this as my client modules will call many functions which contains select/update/delete statements.Anonymoushttps://www.blogger.com/profile/00860584309981423591noreply@blogger.comtag:blogger.com,1999:blog-3802120172110116696.post-47716211138142912242020-04-20T08:56:07.699+09:002020-04-20T08:56:07.699+09:00This comment has been removed by a blog administrator.Kumpulan Situs Judi Online Terlengkaphttps://www.blogger.com/profile/03591892354935811870noreply@blogger.comtag:blogger.com,1999:blog-3802120172110116696.post-4240142798005636032020-03-03T11:04:55.314+09:002020-03-03T11:04:55.314+09:00This comment has been removed by a blog administrator.Kumpulan Situs Judi Online Terpercaya 2020https://www.blogger.com/profile/18181234718188456422noreply@blogger.comtag:blogger.com,1999:blog-3802120172110116696.post-9028636900640688152020-02-17T20:00:31.482+09:002020-02-17T20:00:31.482+09:00This comment has been removed by a blog administrator.rhetthttps://www.blogger.com/profile/10585213432402533504noreply@blogger.comtag:blogger.com,1999:blog-3802120172110116696.post-83552929094788261822020-02-13T22:56:36.356+09:002020-02-13T22:56:36.356+09:00This comment has been removed by a blog administrator.danielhttps://www.blogger.com/profile/17296656990213457948noreply@blogger.comtag:blogger.com,1999:blog-3802120172110116696.post-76281167840716418152020-02-12T23:29:48.725+09:002020-02-12T23:29:48.725+09:00This comment has been removed by a blog administrator.Situs Judi Online 2020https://www.blogger.com/profile/07106462376979340880noreply@blogger.comtag:blogger.com,1999:blog-3802120172110116696.post-65189309754090605532020-02-07T15:23:53.804+09:002020-02-07T15:23:53.804+09:00This comment has been removed by a blog administrator.willian vivianhttps://www.blogger.com/profile/17277927974072792152noreply@blogger.comtag:blogger.com,1999:blog-3802120172110116696.post-73763277804559542212020-01-27T01:58:01.537+09:002020-01-27T01:58:01.537+09:00This comment has been removed by a blog administrator.Kumpulan Game Judi Onlinehttps://www.blogger.com/profile/03698412477262817373noreply@blogger.comtag:blogger.com,1999:blog-3802120172110116696.post-88548947381731823232020-01-22T11:23:21.551+09:002020-01-22T11:23:21.551+09:00This comment has been removed by a blog administrator.danielhttps://www.blogger.com/profile/17296656990213457948noreply@blogger.comtag:blogger.com,1999:blog-3802120172110116696.post-33229852394625221082020-01-21T20:53:56.311+09:002020-01-21T20:53:56.311+09:00This comment has been removed by a blog administrator.BENNY MEITIShttps://www.blogger.com/profile/09204985549682122742noreply@blogger.comtag:blogger.com,1999:blog-3802120172110116696.post-20502954383352903362020-01-13T10:20:42.094+09:002020-01-13T10:20:42.094+09:00This comment has been removed by a blog administrator.Doris Susanhttps://www.blogger.com/profile/00462531412081635393noreply@blogger.com