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

Reply via email to