Mon Apr 24 10:14:09 PDT 2006
- Previous message: [Slony1-general] wait interval in slon cleanup thread
- Next message: [Slony1-general] wait interval in slon cleanup thread
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
On Mon, Apr 24, 2006 at 02:51:22PM +0000, Christopher Browne wrote: > As far as lower bound goes, I don't see too much problem there. The > value is used to determine how long the cleanup thread sleeps between > invocations. The shortest that could *possibly* fall to is zero, in > which case it would run continually. Wouldn't that result in the thread continuously polling the database, presenting an unreasonable load? I guess in some cases if you're paranoid about database size and don't care about performance that might be ok, but ISTM there should at least be a warning in the docs. Another concern is that running in that mode could cause an XID rollover relatively quickly. -- Jim C. Nasby, Sr. Engineering Consultant jnasby at pervasive.com Pervasive Software http://pervasive.com work: 512-231-6117 vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461
- Previous message: [Slony1-general] wait interval in slon cleanup thread
- Next message: [Slony1-general] wait interval in slon cleanup thread
- Messages sorted by: [ date ] [ thread ] [ subject ] [ author ]
More information about the Slony1-general mailing list