Re: [PERFORM] Improving Inner Join Performance

2006-01-08 Thread Andy
shared_buffers = 10240effective_cache_size = 64000RAM on server: 1Gb. Andy. - Original Message - From: "Frank Wiles" <[EMAIL PROTECTED]> To: "Andy" <[EMAIL PROTECTED]> Sent: Friday, January 06, 2006 7:12 PM Subject: Re: [PERFORM] Improving Inner Join Performance > On Fri, 6 Jan 2006

Re: [PERFORM] help tuning queries on large database

2006-01-08 Thread Ron
I'll second all of Luke Lonergan's comments and add these. You should be able to increase both "cold" and "warm" performance (as well as data integrity. read below.) considerably. Ron At 05:59 PM 1/6/2006, peter royal wrote: Howdy. I'm running into scaling problems when testing with a 16gb

Re: [PERFORM] help tuning queries on large database

2006-01-08 Thread Luke Lonergan
Peter, On 1/6/06 2:59 PM, "peter royal" <[EMAIL PROTECTED]> wrote: > I have experimented with having all 8 disks in a single RAID0 set, a > single RAID10 set, and currently 4 RAID0 sets of 2 disks each. There > hasn't been an appreciable difference in the overall performance of > my test suite (w