Re: [PERFORM] Postgresql on an AMD64 machine

2005-06-08 Thread Sam Vilain
Joshua D. Drake wrote: Yes - we have seen with oracle 64 bit that there can be as much as a 10% hit moving from 32 - but we make it up big time with large db-buffer sizes that drastically Well for Opteron you should also gain from the very high memory bandwidth and the fact that it has I believ

Re: [PERFORM] Prefetch

2005-05-10 Thread Sam Vilain
Matt Olson wrote: Other databases like Oracle and DB2 implement some sort of row prefetch. Has there been serious consideration of implementing something like a prefetch subsystem? Does anyone have any opinions as to why this would be a bad idea for postgres? Postges is great for a multiuser envi

Re: [PERFORM] Whence the Opterons?

2005-05-08 Thread Sam Vilain
Mischa Sandberg wrote: After reading the comparisons between Opteron and Xeon processors for Linux, I'd like to add an Opteron box to our stable of Dells and Sparcs, for comparison. IBM, Sun and HP have their fairly pricey Opteron systems. The IT people are not swell about unsupported purchases of