Jan Wieck wrote:
I will follow up shortly with an approach that integrates Tom's delay mechanism plus my first READ_BY_VACUUM hack into one combined experiement.
Okay,
the attached patch contains the 3 already discussed and one additional change.
Ooopsy
the B1/B2 queue length adjustment in that one was totally nonsense. This one behaves much better.
I added a DEBUG1 elog every 10 seconds to monitor the cache hitrates and cache size adjustments. It's pretty neat to watch how it responds to running an OLTP kind of thing and then issue VACUUM and run big reporting sequential suckers in parallel.
Jan
-- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #================================================== [EMAIL PROTECTED] #
all_performance.v2.74.diff.gz
Description: GNU Zip compressed data
---------------------------(end of broadcast)--------------------------- TIP 4: Don't 'kill -9' the postmaster
