Re: [PERFORM] a lot of problems with pg 7.4

2003-12-14 Thread Tarhon-Onu Victor
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 but there's also some strange slowness that I can't

Re: [PERFORM] a lot of problems with pg 7.4

2003-12-14 Thread Dennis Bjorklund
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

[PERFORM] a lot of problems with pg 7.4

2003-12-13 Thread Kari Lavikka
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