Skip site navigation (1) Skip section navigation (2)

Re: a lot of problems with pg 7.4

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: (view raw, whole thread or download thread mbox)
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.

In response to

pgsql-performance by date

Next:From: Nick Fankhauser - DoxpopDate: 2003-12-16 17:06:20
Subject: Nested loop question
Previous:From: Claudia D'amatoDate: 2003-12-16 15:40:03
Subject: Postgres respond after toomany times to a query view

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group