Thread: Testing strategies

I have a client wanting to test PostgreSQL on ZFS running Linux.

Other than pg_bench are there any other benchmarks that are easy to test?

One of the possible concerns is fragmentation over time. Any ideas on how
to fragment the database before running pg_bench ?

Also there is some concern about fragmentation of the WAL logs. I am
looking at testing with and without the WAL logs on ZFS. Any other specific
concerns ?


Dave Cramer
credativ ltd (Canada)

78 Zina St
Orangeville, ON
Canada. L9W 1E8

Office: +1 (905) 766-4091
Mobile: +1 (519) 939-0336

===================================
Canada:      http://www.credativ.ca
USA:         http://www.credativ.us
Germany:     http://www.credativ.de
Netherlands: http://www.credativ.nl
UK:          http://www.credativ.co.uk
India:       http://www.credativ.in
===================================