On Sat, 13 Dec 2003, Kari Lavikka wrote: > > Hi! > > We have been running a rather busy website using pg 7.3 as the database. > Peak hitrate is something like 120 request / second without images and > other static stuff. The site is a sort of image gallery for IRC users. > > I evaluated pg 7.4 on our development server and it looked just fine > but performance with production loads seems to be quite poor. Most of > performance problems are caused by nonsensical query plans but there's > also some strange slowness that I can't locate.
Have you analyzed your database since putting the new data into it? Also, you might need to increase your statistics target before analyzing to get proper results as well. ---------------------------(end of broadcast)--------------------------- TIP 8: explain analyze is your friend