| From: | Dennis Bjorklund <db(at)zigo(dot)dhs(dot)org> |
|---|---|
| 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-14 17:14:00 |
| Message-ID: | Pine.LNX.4.44.0312141809580.10157-100000@zigo.dhs.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-performance |
On Sat, 13 Dec 2003, Kari Lavikka wrote:
> 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
Some of the estimates that pg made in the plans you showed was way off. I
assume you have run VACUUM ANALYZE recently? If that does not help maybe
you need to increaste the statistics gathering on some columns so that pg
makes better estimates. With the wrong statistics it's not strange that pg
chooses bad plans.
--
/Dennis
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Andrew Sullivan | 2003-12-14 17:55:48 | Re: Tuning for mid-size server |
| Previous Message | Tarhon-Onu Victor | 2003-12-14 09:54:41 | Re: a lot of problems with pg 7.4 |