[PERFORM] Hardware opinions wanted

2004-05-27 Thread Dan Harris
I wanted to solicit some opinions on architecture and performance from you guys. I am torn right now between these two systems to replace my aging DB server: 4 x 2.2 GHz Opteron 8GB RAM Ultra320 15kRPM RAID5 with 128MB cache and 2-way 1.2GHz POWER4+ IBM pSeries 615 8GB RAM Ultra320 15kRPM RAID5 w

Re: [PERFORM] PostgreSQL caching

2004-05-27 Thread Matthew Nuzum
> > Hello Josh, > > JB> Not that you can't improve the query, just that it might not fix > JB> the problem. > > Yes, I'm aware it might be slower than the Linux version, but then, as > you said, I still can improve the query (as I did with your help now). > > But true, if there's something awfu