On Thu, 25 Apr 2002, mlw wrote: > ...but my gut tells me that using 16K blocks will increase performance > over 8K. Aleady I have seen a sequential scan of a large table go from 20 > seconds using 8K to 17.3 seconds using 16K.
You should be able to get the same performance increase with 8K blocks by reading two blocks at a time while doing sequential scans. That's why I've been promoting this idea of changing postgres to do its own read-ahead. Of course, Bruce might be right that the OS read-ahead may take care of this anyway, but then why would switching to 16K blocks improve sequential scans? Possibly because I'm missing something here. Anyway, we now know how to test the change, should someone do it: compare sequential scans with and without readahead on 8K blocks, and then compare that against a server without readahead but with block sizes the size of the readahead (64K, I propose--oh wait, we can only do 32K....) cjs -- Curt Sampson <[EMAIL PROTECTED]> +81 90 7737 2974 http://www.netbsd.org Don't you know, in this new Dark Age, we're all light. --XTC ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]
