Postgres Pro
Downloads
Home   >   mailing lists

Thread: [TEST REPORT]

[TEST REPORT]

From
"Marcel Gsteiger"
Date:

[TEST REPORT]

[Release]: 9.0beta1

[Test Type]: application

[Test]: 9.0beta1 Installation, Migration of data from 8.4 using dump/restore, running a 40GB database with Zabbix 1.8.2

[Platform]: Linux CentOS 5.4/5.5 x86_64 running on HP Proliant ML110G5 w/SMART array controller, SAS RAID 10 Array

[Results]: dump/restore (using 9.0beta1 dump against 8.4 database and restore to 9.0beta1) worked flawlessly, as does zabbix. Performance is comparable to 8.4 (no problems with the system inserting and deleting 50 rows per second 24*7). Now running 10 days - originally installed on CentOS 5.4, meanwhile upgraded to CentOS 5.5, still works flawlessly.[Comments]: modified postgresql.conf for this test, mainly larger buffers (8GB RAM available). Performance comparison is somewhat difficult since not only software has changed but RAID hardware as well. But certainly with 9.0beta1 nothing has become worse.



Re: [TEST REPORT]

From
Josh Berkus
Date:
> *[Results]:* dump/restore (using 9.0beta1 dump against 8.4 database and
> restore to 9.0beta1) worked flawlessly, as does zabbix. Performance is
> comparable to 8.4 (no problems with the system inserting and deleting 50
> rows per second 24*7). Now running 10 days - originally installed on
> CentOS 5.4, meanwhile upgraded to CentOS 5.5, still works flawlessly.

Thanks for this, performance comparison is especially useful.

--
                                   -- Josh Berkus
                                      PostgreSQL Experts Inc.
                                      http://www.pgexperts.com