I'm facing a very weird problem. Recently our database run very slow when execute Delete/Select statement for a few tables only.. The largest table only have 50K rows of data. When I run the statement from pgAdmin although it is slow but not as slow as run from webapp. When I run the statement from webapp, it become extremely slow. Even a simple delete statement will takes 20-40 minutes to complete. I already vacuum those tables with full option but it still the same. What could be the possible causes of this problem? How can I solve it? CPU - Intel Xeon 2.40 GHz Memory - 1.5G Postgresql version: 7.2.2 Thanks.
