Penguin

Differences between version 14 and previous revision of PgBench.

Other diffs: Previous Major Revision, Previous Author, or view the Annotated Edit History

Newer page: version 14 Last edited on Thursday, June 15, 2006 7:59:06 pm by GuyThornley Revert
Older page: version 13 Last edited on Thursday, June 15, 2006 7:06:25 pm by GuyThornley Revert
@@ -183,5 +183,14 @@
  <pre> 
  </pre> 
  
 ---- 
+Other observations  
+* The test database started at 1.4GB, and got to at least 14GB during testing, has this growth affected results?  
+* The WAL consumes large amounts of kernel page cache. When moving the WAL between devices, when the old files are unlinked,  
+ 1/2 of the page cache is freed. The WAL is never read, and written only once, this is as waste!  
+* The BBWC makes write performance very erratic  
+* The HP SmartArray hardware (or perhaps driver) tends to block reads while there are cached writes occuring. Large read latencies (seconds) results. I have not yet found a way to tune this.  
+  
+----  
+  
 CategoryDiskNotes