| Lists: | pgsql-testers |
|---|
| From: | "Marcel Gsteiger" <Marcel(dot)Gsteiger(at)milprog(dot)ch> |
|---|---|
| To: | <pgsql-testers(at)postgresql(dot)org> |
| Subject: | [TEST REPORT] |
| Date: | 2010-05-21 20:01:35 |
| Message-ID: | 4BF702BF0200001000058D72@mailgw.milnet.ch |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-testers |
[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.
| From: | Josh Berkus <josh(at)agliodbs(dot)com> |
|---|---|
| To: | pgsql-testers(at)postgresql(dot)org |
| Subject: | Re: [TEST REPORT] |
| Date: | 2010-05-22 15:18:29 |
| Message-ID: | 4BF7F5C5.7000007@agliodbs.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-testers |
> *[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