Changes between Version 1 and Version 2 of FAQ

Show
Ignore:
Timestamp:
01/21/06 16:22:18 (13 years ago)
Author:
benoitg
Comment:

Add FAQ for progressive slowdown problem

Legend:

Unmodified
Added
Removed
Modified
  • FAQ

    v1 v2  
    158158Q: Can I extract the hotspot status data in XML format ? 
    159159  A: Yes, the hotspots status list can be exported to a XML. In fact, the Google Maps mashup part of Wifidog relies on this feature. [http://ilesansfil.org/tiki-index.php?page=HotSpots Île Sans Fil is also using it] to create a specially formatted display on its main website using [http://auth.ilesansfil.org/xslt/wifidog_status.xsl an XSL stylesheet]. 
     160 
     161Q: My auth server used to be fast, but now it's slower and slower, even under no load 
     162 
     163  A: You have to: 
     164 
     165 1. Run VACUUM ANALYSE often from a script (it's a very cheap, non locking operation, and considering wifidog's very write heavy SQL mix, runing it every hour isn't excessive). 
     166 1. Make sure the above script works. 
     167 1. If you see you auth server getting progressively slower, run  VACUUM FULL ANALYSE once, and GO TO STEP 2. 
     168 
     169 Explanation:  If you run VACUUM ANALYSE regularily (every night or every hour) you shouldn't need VACUUM FULL ANALYSE. However, if you haven't run VACUUM ANALYSE for a long time, you have to run VACUUM FULL ANALYZE once.  
     170 
     171 What happens is that without VACUUMing the connection and node tables grows and grows (because they are written to frequently, and postgres being a true ACID database, keep past versions of tuples to insure read consistency).  Simply vacuuming doesn't reclaim the space used by old tuples, it just makes them available for reuse.  If you haven't run VACUUM in a long time, you probably have millions of free tuples that you would, never, ever  
     172use up in a single day.  VACUUM FULL ANALYZE fixes that.