<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=iso-8859-1">
<style type="text/css" style="display:none;"> P {margin-top:0;margin-bottom:0;} </style>
</head>
<body dir="ltr">
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
Hi,</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
I try to speed up our application by moving READ-ONLY PostgreSQL replica near our Far East office.</div>
<div style="font-family: Calibri, Arial, Helvetica, sans-serif; font-size: 12pt; color: rgb(0, 0, 0);">
<br>
</div>
<div style=""><font color="#000000" face="Calibri, Arial, Helvetica, sans-serif"><span style="font-size: 12pt;">The idea is to keep RW </span></font><span style="background-color: rgb(255, 255, 255); display: inline !important;"><font color="#000000" face="Calibri, Arial, Helvetica, sans-serif"><span style="font-size: 12pt;">PostgreSQL database
in Europe and a </span></font><span style="background-color: rgb(255, 255, 255); display: inline !important;"><font color="#000000" face="Calibri, Arial, Helvetica, sans-serif"><span style="font-size: 12pt;">READ-ONLY PostgreSQL replica (streaming) in </span></font><span style="background-color: rgb(255, 255, 255); display: inline !important;"><font color="#000000" face="Calibri, Arial, Helvetica, sans-serif"><span style="font-size: 12pt;">Far
East; then create a pgpool in <span style="font-family: Calibri, Arial, Helvetica, sans-serif; background-color: rgb(255, 255, 255); display: inline !important">Far East<span> </span></span> that write only in </span></font><span style="background-color: rgb(255, 255, 255); display: inline !important;"><font color="#000000" face="Calibri, Arial, Helvetica, sans-serif"><span style="font-size: 12pt;">Europe (few
big write) and read (</span>many little read<span style="font-size: 12pt;">) on <span style="font-family: Calibri, Arial, Helvetica, sans-serif; background-color: rgb(255, 255, 255); display: inline !important">Far East database, and create a new application
server <span style="font-family: Calibri, Arial, Helvetica, sans-serif; background-color: rgb(255, 255, 255); display: inline !important">Far East.</span></span></span></font></span></span></span></span></div>
<div style=""><span style="background-color: rgb(255, 255, 255); display: inline !important;"><span style="background-color: rgb(255, 255, 255); display: inline !important;"><span style="background-color: rgb(255, 255, 255); display: inline !important;"><span style="background-color: rgb(255, 255, 255); display: inline !important;"><font color="#000000" face="Calibri, Arial, Helvetica, sans-serif"><span style="font-size: 12pt;"><span style="font-family: Calibri, Arial, Helvetica, sans-serif; background-color: rgb(255, 255, 255); display: inline !important"><span style="font-family: Calibri, Arial, Helvetica, sans-serif; background-color: rgb(255, 255, 255); display: inline !important"><br>
</span></span></span></font></span></span></span></span></div>
<div style=""><span style="background-color: rgb(255, 255, 255); display: inline !important;"><span style="background-color: rgb(255, 255, 255); display: inline !important;"><span style="background-color: rgb(255, 255, 255); display: inline !important;"><span style="background-color: rgb(255, 255, 255); display: inline !important;"><font color="#000000" face="Calibri, Arial, Helvetica, sans-serif"><span style="font-size: 12pt;"><span style="font-family: Calibri, Arial, Helvetica, sans-serif; background-color: rgb(255, 255, 255); display: inline !important"><span style="font-family: Calibri, Arial, Helvetica, sans-serif; background-color: rgb(255, 255, 255); display: inline !important">I
created a test environment, it works fine but is very slow. It seems that pgpool route statements correctly (RW to <span style="font-family: Calibri, Arial, Helvetica, sans-serif; background-color: rgb(255, 255, 255); display: inline !important">Europe, and
READ to <span style="font-family: Calibri, Arial, Helvetica, sans-serif; background-color: rgb(255, 255, 255); display: inline !important">Far East) but there are many query to pg_catalog (RW) that seem to slow down the application server.</span></span></span></span></span></font></span></span></span></span></div>
<div style=""><span style="background-color: rgb(255, 255, 255); display: inline !important;"><span style="background-color: rgb(255, 255, 255); display: inline !important;"><span style="background-color: rgb(255, 255, 255); display: inline !important;"><span style="background-color: rgb(255, 255, 255); display: inline !important;"><font color="#000000" face="Calibri, Arial, Helvetica, sans-serif"><span style="font-size: 12pt;"><span style="font-family: Calibri, Arial, Helvetica, sans-serif; background-color: rgb(255, 255, 255); display: inline !important"><span style="font-family: Calibri, Arial, Helvetica, sans-serif; background-color: rgb(255, 255, 255); display: inline !important"><span style="font-family: Calibri, Arial, Helvetica, sans-serif; background-color: rgb(255, 255, 255); display: inline !important"><span style="font-family: Calibri, Arial, Helvetica, sans-serif; background-color: rgb(255, 255, 255); display: inline !important"><br>
</span></span></span></span></span></font></span></span></span></span></div>
<div style=""><font color="#000000" face="Calibri, Arial, Helvetica, sans-serif">This is an example;</font></div>
<div style=""><span style="background-color: rgb(255, 255, 255); display: inline !important;"><span style="background-color: rgb(255, 255, 255); display: inline !important;"><span style="background-color: rgb(255, 255, 255); display: inline !important;"><span style="background-color: rgb(255, 255, 255); display: inline !important;"><font color="#000000" face="Calibri, Arial, Helvetica, sans-serif"><span style="font-size: 12pt;"><span style="font-family: Calibri, Arial, Helvetica, sans-serif; background-color: rgb(255, 255, 255); display: inline !important"><span style="font-family: Calibri, Arial, Helvetica, sans-serif; background-color: rgb(255, 255, 255); display: inline !important"><span style="font-family: Calibri, Arial, Helvetica, sans-serif; background-color: rgb(255, 255, 255); display: inline !important"><span style="font-family: Calibri, Arial, Helvetica, sans-serif; background-color: rgb(255, 255, 255); display: inline !important">SELECT
count(*) FROM pg_catalog.pg_class AS c WHERE c.oid = pg_catalog.to_regclass('"XXX"."YYYY"') AND c.relpersistence = 'u'<br>
</span></span></span></span></span></font></span></span></span></span></div>
<div style=""><span style="background-color: rgb(255, 255, 255); display: inline !important;"><span style="background-color: rgb(255, 255, 255); display: inline !important;"><span style="background-color: rgb(255, 255, 255); display: inline !important;"><span style="background-color: rgb(255, 255, 255); display: inline !important;"><font color="#000000" face="Calibri, Arial, Helvetica, sans-serif"><span style="font-size: 12pt;"><span style="font-family: Calibri, Arial, Helvetica, sans-serif; background-color: rgb(255, 255, 255); display: inline !important"><span style="font-family: Calibri, Arial, Helvetica, sans-serif; background-color: rgb(255, 255, 255); display: inline !important"><span style="font-family: Calibri, Arial, Helvetica, sans-serif; background-color: rgb(255, 255, 255); display: inline !important"><span style="font-family: Calibri, Arial, Helvetica, sans-serif; background-color: rgb(255, 255, 255); display: inline !important"><br>
</span></span></span></span></span></font></span></span></span></span></div>
<div style=""><font color="#000000" face="Calibri, Arial, Helvetica, sans-serif">Can someone suggest how to go on?</font></div>
<div style=""><font color="#000000" face="Calibri, Arial, Helvetica, sans-serif"><br>
</font></div>
<div style=""><font color="#000000" face="Calibri, Arial, Helvetica, sans-serif">Thanks.</font></div>
</body>
</html>