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