Re: [PERFORM] General performance questions about postgres on Apple hardware...

2004-02-23 Thread Simon Riggs
>Sean Shanny > Hardware: Apple G5 dual 2.0 with 8GB memory attached via dual fibre > channel to a fully loaded 3.5TB XRaid. The XRaid is configured as two 7 > disk hardware based RAID5 sets software striped to form a RAID50 set. > The DB, WALS, etc are all on that file set. Running OSX journaled

[PERFORM] General performance questions about postgres on Apple hardware...

2004-02-20 Thread Sean Shanny
To all, This is a 2 question email. First is asking about general tuning of the Apple hardware/postgres combination. The second is whether is is possible to speed up a particular query. PART 1 Hardware: Apple G5 dual 2.0 with 8GB memory attached via dual fibre channel to a fully loaded 3.5