<html><body><div style="color:#000; background-color:#fff; font-family:times new roman, new york, times, serif;font-size:10pt">I mean, let's say I define the value of relcache_expire as "600" seconds. and the TABLE in cache is ALTERED before that. That means my query will produce the wrong result because the relation cache is not yet updated/expired, right? On what basis one would define the value of relcache_expire in pgpool.conf?<br><br><div style="font-family: times new roman, new york, times, serif; font-size: 10pt;"> <div style="font-family: times new roman, new york, times, serif; font-size: 12pt;"> <div dir="ltr"> <font size="2" face="Arial"> <hr size="1"> <b><span style="font-weight:bold;">From:</span></b> Sandeep Thakkar <sandeeptt@yahoo.com><br> <b><span style="font-weight: bold;">To:</span></b> "pgpool-general@pgpool.net" <pgpool-general@pgpool.net> <br> <b><span style="font-weight: bold;">Sent:</span></b> Monday, February 13,
2012 1:58 PM<br> <b><span style="font-weight: bold;">Subject:</span></b> [pgpool-general: 220] More information on relcache_expire<br> </font> </div> <br>
<div id="yiv362737685"><div><div style="color:#000;background-color:#fff;font-family:times new roman, new york, times, serif;font-size:10pt;"><pre>- Add relcache_expire directive to control the expiration of the
internal system catalog cache. ALTER TABLE might make these
cache values obsoleted and the new directive will make the risk
lower(Tatsuo)</pre><div> I would like to know how to make use of this directive? A test case will help.<br><br>Thanks.<br></div><div><br></div></div></div></div><br>_______________________________________________<br>pgpool-general mailing list<br><a ymailto="mailto:pgpool-general@pgpool.net" href="mailto:pgpool-general@pgpool.net">pgpool-general@pgpool.net</a><br><a href="http://www.pgpool.net/mailman/listinfo/pgpool-general" target="_blank">http://www.pgpool.net/mailman/listinfo/pgpool-general</a><br><br><br> </div> </div> </div></body></html>