| From: | Dave Cramer <davecramer(at)gmail(dot)com> |
|---|---|
| To: | pgsql-performance <pgsql-performance(at)postgresql(dot)org> |
| Subject: | Testing strategies |
| Date: | 2014-04-15 15:57:29 |
| Message-ID: | CADK3HHJt0cHY=6S4KBYu7i1kM-jDTsCABSq=_RPQQL0mjqyL8A@mail.gmail.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
===================================
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Rob Sargent | 2014-04-15 16:02:08 | Re: Approach to Data Summary and Analysis |
| Previous Message | Robert DiFalco | 2014-04-15 15:53:04 | Re: [GENERAL] Approach to Data Summary and Analysis |