Re: [PERFORM] What's the best hardver for PostgreSQL 8.1?

2005-12-25 Thread Michael Stone
On Sat, Dec 24, 2005 at 05:45:20PM -0500, Ron wrote: Caches help, and the bigger the cache the better, but once you are doing enough writes fast enough (and that doesn't take much even with a few GBs of cache) the recalculate-checksums-and-write-new-ones overhead will decrease the write speed o

Re: [PERFORM] What's the best hardver for PostgreSQL 8.1?

2005-12-25 Thread Bruno Wolff III
On Sat, Dec 24, 2005 at 22:13:43 -0500, Luke Lonergan <[EMAIL PROTECTED]> wrote: > David, > > > now hot-swap may not be supported on all interface types, that may be what > > you have run into, but with SCSI or SATA you should be able to hot-swap > > with the right controller. > > That's actu

Re: [PERFORM] What's the best hardver for PostgreSQL 8.1?

2005-12-25 Thread Steinar H. Gunderson
On Sun, Dec 25, 2005 at 04:13:57AM -0800, David Lang wrote: > Thanks for the clarification, I knew that PATA didn't do hotswap, and I've > seen discussions on the linux-kernel list about SATA hotswap being worked > on, but I thought that scsi handled it. how recent a kernel have you had > proble

Re: [PERFORM] What's the best hardver for PostgreSQL 8.1?

2005-12-25 Thread David Lang
On Sat, 24 Dec 2005, Luke Lonergan wrote: David, now hot-swap may not be supported on all interface types, that may be what you have run into, but with SCSI or SATA you should be able to hot-swap with the right controller. That's actually the problem - Linux hot swap is virtually non-functio