[PERFORM] hardware upgrade, performance degrade?

2013-03-01 Thread Steven Crandell
Recently I moved my ~600G / ~15K TPS database from a 48 core@2.0GHz server with 512GB RAM on 15K RPM disk to a newer server with 64 core@2.2Ghz server with 1T of RAM on 15K RPM disks The move was from v9.1.4 to v9.1.8 (eventually also tested with v9.1.4 on the new hardware) and was done via base b

[PERFORM] New server setup

2013-03-01 Thread Niels Kristian Schjødt
Hi, I'm going to setup a new server for my postgresql database, and I am considering one of these: http://www.hetzner.de/hosting/produkte_rootserver/poweredge-r720 with four SAS drives in a RAID 10 array. Has any of you any particular comments/pitfalls/etc. to mention on the setup? My applicati

Re: [PERFORM] xmlconcat performance

2013-03-01 Thread Merlin Moncure
On Fri, Mar 1, 2013 at 2:18 AM, Davide Berra wrote: > Il 28/02/2013 18:48, Merlin Moncure ha scritto: > >> On Fri, Feb 22, 2013 at 3:21 AM, Davide Berra >> wrote: >>> >>> I got a problem with the performance of a PL/PGsql stored procedure >>> outputting an xml. >>> >>> Server version: PostgreSQL

Re: [PERFORM] New server setup

2013-03-01 Thread Craig James
On Fri, Mar 1, 2013 at 3:43 AM, Niels Kristian Schjødt < nielskrist...@autouncle.com> wrote: > Hi, I'm going to setup a new server for my postgresql database, and I am > considering one of these: > http://www.hetzner.de/hosting/produkte_rootserver/poweredge-r720 with > four SAS drives in a RAID 10

Re: [PERFORM] hardware upgrade, performance degrade?

2013-03-01 Thread Craig James
On Fri, Mar 1, 2013 at 1:52 AM, Steven Crandell wrote: > Recently I moved my ~600G / ~15K TPS database from a > 48 core@2.0GHz server with 512GB RAM on 15K RPM disk > to a newer server with > 64 core@2.2Ghz server with 1T of RAM on 15K RPM disks > > The move was from v9.1.4 to v9.1.8 (eventually a

Re: [PERFORM] hardware upgrade, performance degrade?

2013-03-01 Thread Steven Crandell
We saw the same performance problems when this new hardware was running cent 6.3 with a 2.6.32-279.19.1.el6.x86_64 kernel and when it was matched to the OS/kernel of the old hardware which was cent 5.8 with a 2.6.18-308.11.1.el5 kernel. Yes the new hardware was thoroughly tested with bonnie before

Re: [PERFORM] New server setup

2013-03-01 Thread Wales Wang
pls choice PCI-E Flash for written heavy app Wales 在 2013-3-1，下午8:43，Niels Kristian Schjødt 写道： > Hi, I'm going to setup a new server for my postgresql database, and I am > considering one of these: > http://www.hetzner.de/hosting/produkte_rootserver/poweredge-r720 with four > SAS drives in

Re: [PERFORM] hardware upgrade, performance degrade?

2013-03-01 Thread Scott Marlowe
On Fri, Mar 1, 2013 at 9:49 AM, Steven Crandell wrote: > We saw the same performance problems when this new hardware was running cent > 6.3 with a 2.6.32-279.19.1.el6.x86_64 kernel and when it was matched to the > OS/kernel of the old hardware which was cent 5.8 with a 2.6.18-308.11.1.el5 > kernel

Re: [PERFORM] hardware upgrade, performance degrade?

2013-03-01 Thread Jesper Krogh
On 01/03/2013, at 10.52, Steven Crandell wrote: > Recently I moved my ~600G / ~15K TPS database from a > 48 core@2.0GHz server with 512GB RAM on 15K RPM disk > to a newer server with > 64 core@2.2Ghz server with 1T of RAM on 15K RPM disks > > The move was from v9.1.4 to v9.1.8 (eventually als