On 26 Oct 2002, Pandurang wrote: > But Later on as the DB size get increased the time was also get > increased. And at one point i noticed the time required to gererate > this report is very high near abt 10 to 15 hrs. So I checked for > performanance. > > Site was also become very slow. A simple page which is fetching just > 20 records, for that also I got the error page not displayed.I tried > my level best to find out the problem. But I couldn't...!!! :-(( > > So at last I decided to drop DB and recreate once more after taking > backup of data. And I did that. After that i was surprised that site > become very very fast. And the pages for which I got the error comes > in less than 10 seconds. > > So can u tell me why this happens ? Why suddenly DB performanance get > increased so fastly ? Prev.ly I tried for vacuumdb also....
You tried vacuuming, but were you doing analyze (I believe -z to vacuumdb)? What does explain show for the queries in question? ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/users-lounge/docs/faq.html
