From: | "scott(dot)marlowe" <scott(dot)marlowe(at)ihs(dot)com> |
---|---|
To: | Kari Lavikka <tuner(at)bdb(dot)fi> |
Cc: | <pgsql-performance(at)postgresql(dot)org> |
Subject: | Re: a lot of problems with pg 7.4 |
Date: | 2003-12-16 16:37:28 |
Message-ID: | Pine.LNX.4.33.0312160936280.7388-100000@css120.ihs.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-performance |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Nick Fankhauser - Doxpop | 2003-12-16 17:06:20 | Nested loop question |
Previous Message | Claudia D'amato | 2003-12-16 15:40:03 | Postgres respond after toomany times to a query view |