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

Re: [PERFORM] Tuning for mid-size server

2003-12-14 Thread Andrew Sullivan
On Sun, Dec 14, 2003 at 12:42:21AM -0500, Bruce Momjian wrote: I know this is an old email, but have you tested larger shared buffers in CVS HEAD with Jan's new cache replacement policy? Not yet. It's on our TODO list, for sure, because the consequences of relying too much on the filesystem

Re: [PERFORM] Tables Without OIDS and its effect

2003-12-14 Thread Tom Lane
Neil Conway [EMAIL PROTECTED] writes: BTW, we intend to phase out the use of OIDs for user tables in the long term. I don't believe anyone has proposed removing the facility altogether. There's a big difference between making the default behavior be not to have OIDs and removing the ability to

Re: [PERFORM] Tables Without OIDS and its effect

2003-12-14 Thread Neil Conway
Tom Lane [EMAIL PROTECTED] writes: I don't believe anyone has proposed removing the facility altogether. There's a big difference between making the default behavior be not to have OIDs and removing the ability to have OIDs. Right, that's what I had meant to say. Sorry for the inaccuracy.