From all that I've read, adding at least 2 gigs of ram gets you into the "sweet-spot" for PSCS.
I added two gigs but will add another gig very soon so I can give PSCS 2 gigs of it's own.
I've now had my G5 2gig dual for a week and this is how I modified it for my use as a PS machine
added a second 160 SATA Drive ($150) and
downloaded
Atto express stripe
so I could run my drives in both RAID 0 volumes & Standard volumes.
Each drive has a boot volume (standard) and a scratch (RAID) and storage (RAID)
30 gb boot X2 - 30 gb scratch - 200gb storage
I did have a bit of trouble doing the config of the drives (from a FW boot drive)
It seems that OS10.3 has some issues with permissions. If you got this route
and run into problems I'd be glad to give you the advice I received from one of the PS / Mac gurus...
best,
Mel