Testing strategies - Mailing list pgsql-performance

From Dave Cramer
Subject Testing strategies
Date
Msg-id CADK3HHJt0cHY=6S4KBYu7i1kM-jDTsCABSq=_RPQQL0mjqyL8A@mail.gmail.com
Whole thread Raw
Responses Re: Testing strategies
List pgsql-performance
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
===================================

pgsql-performance by date:

Previous
From: Robert DiFalco
Date:
Subject: Re: [GENERAL] Approach to Data Summary and Analysis
Next
From: Nick Eubank
Date:
Subject: Re: Tuning Postgres for Single connection use