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
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
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