On Tue, Dec 06, 2005 at 01:40:47PM +0300, Olleg wrote: > I can't undestand why "bigger is better". For instance in search by > index. Index point to page and I need load page to get one row. Thus I > load 8kb from disk for every raw. And keep it then in cache. You > recommend 64kb. With your recomendation I'll get 8 times more IO > throughput, 8 time more head seek on disk, 8 time more memory cache (OS > cache and postgresql) become busy.
Hopefully, you won't have eight times the seeking; a single block ought to be in one chunk on disk. You're of course at your filesystem's mercy, though. /* Steinar */ -- Homepage: http://www.sesse.net/ ---------------------------(end of broadcast)--------------------------- TIP 4: Have you searched our list archives? http://archives.postgresql.org
