Re: [PERFORM] Advice sought : new database server

2012-03-04 Thread Scott Marlowe
On Sun, Mar 4, 2012 at 12:45 PM, Andy Colson wrote: > On 03/04/2012 03:58 AM, Rory Campbell-Lange wrote: >> >> I'd be grateful for advice on specifying the new server >> >> providing about 230GB of usable storage, 150GB of which is on an LV >> providing reconfigurable space for the databases which

Re: [PERFORM] Advice sought : new database server

2012-03-04 Thread Scott Marlowe
On Sun, Mar 4, 2012 at 11:36 AM, Rory Campbell-Lange wrote: > On 04/03/12, Scott Marlowe (scott.marl...@gmail.com) wrote: >> The 15k RPM disks aren't that big of a deal unless you're pushing the >> bleeding edge on a transactional system. I'm gonna take a wild guess >> that you're not doing heavy

Re: [PERFORM] Advice sought : new database server

2012-03-04 Thread Andy Colson
On 03/04/2012 03:58 AM, Rory Campbell-Lange wrote: I'd be grateful for advice on specifying the new server providing about 230GB of usable storage, 150GB of which is on an LV providing reconfigurable space for the databases which are served off an XFS formatted volume. Do you mean LVM? I've

Re: [PERFORM] Advice sought : new database server

2012-03-04 Thread Rory Campbell-Lange
On 04/03/12, Scott Marlowe (scott.marl...@gmail.com) wrote: > On Sun, Mar 4, 2012 at 2:58 AM, Rory Campbell-Lange > wrote: > > [About existing server...] We would get faster performance, I > > believe, by providing more RAM. Sorry -- I should have some pg_bench > > output to share here. > > RAM

Re: [PERFORM] Advice sought : new database server

2012-03-04 Thread Scott Marlowe
On Sun, Mar 4, 2012 at 2:58 AM, Rory Campbell-Lange wrote: > I'd be grateful for advice on specifying the new server > > We presently have one main database server which is performing well. As > our services expand we are thinking of bringing another database server > to work with it, and back eac

Re: [PERFORM] Advice sought : new database server

2012-03-04 Thread Michael Friedl
Hey! On 04.03.2012 10:58, Rory Campbell-Lange wrote: > 1U chassis with 8 2.5" disk bays > 2x Intel Xeon E5630 Quad-Core / 4x 2.53GHz / 12MB cache > 8 channel Areca ARC-1880i (PCI Express x8 card) > presumably with BBU (can't see it listed at present) > 2 x 300GB SAS 2.5" dis

[PERFORM] Advice sought : new database server

2012-03-04 Thread Rory Campbell-Lange
I'd be grateful for advice on specifying the new server We presently have one main database server which is performing well. As our services expand we are thinking of bringing another database server to work with it, and back each up via Postgres 9.1 streaming replication each to a VM server -- at