On Sat, 13 Dec 2003, Kari Lavikka wrote:
> 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.
In response to
pgsql-performance by date
|Next:||From: Nick Fankhauser - Doxpop||Date: 2003-12-16 17:06:20|
|Subject: Nested loop question|
|Previous:||From: Claudia D'amato||Date: 2003-12-16 15:40:03|
|Subject: Postgres respond after toomany times to a query view|