-----BEGIN PGP SIGNED MESSAGE----- Hash: SHA1 On Thursday 12 August 2004 06:19 pm, Ganesan wrote: > I have web based application (developed in php) hosted on Redhat 8 > with Apache + PHP. This web based application is connecting to > postgresql database on another redhat 8 linux. > All the while the web based application was running quite smoothly > but recently we have noticed that the performance of the web based > application have become very slow. > It is slow in retrieving records from the database. > I am clueless what might have caused this problem suddenly.
Have you been "vaccuming" your postgres database on a regular basis? Also use the "analyze" command when vaccuming so that your database query planner is optimised in choosing the best path for queries. -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.2.4 (GNU/Linux) iD8DBQFBHdXnfQe5A1YbfuURAo+wAJoCdiKynlsdGdEyjQN+w2HIL7LcsQCeIpg7 d5DHawBDq9itc6C6fxA8KS4= =qGwU -----END PGP SIGNATURE----- ------------------------------------------------------- SF.Net email is sponsored by Shop4tech.com-Lowest price on Blank Media 100pk Sonic DVD-R 4x for only $29 -100pk Sonic DVD+R for only $33 Save 50% off Retail on Ink & Toner - Free Shipping and Free Gift. http://www.shop4tech.com/z/Inkjet_Cartridges/9_108_r285 _______________________________________________ linux-india-help mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/linux-india-help
