Re: a lot of problems with pg 7.4

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.