Re: [GENERAL] Autovacuum Improvements
| От | Ron Mayer | 
|---|---|
| Тема | Re: [GENERAL] Autovacuum Improvements | 
| Дата | |
| Msg-id | 45B51BE3.9050809@cheapcomplexdevices.com обсуждение исходный текст  | 
		
| Ответ на | Re: [GENERAL] Autovacuum Improvements (Gregory Stark <stark@enterprisedb.com>) | 
| Ответы | 
                	
            		Re: [GENERAL] Autovacuum Improvements
            		
            		 | 
		
| Список | pgsql-hackers | 
Gregory Stark wrote: > > Actually no. A while back I did experiments to see how fast reading a file > sequentially was compared to reading the same file sequentially but skipping > x% of the blocks randomly. The results were surprising (to me) and depressing. > The breakeven point was about 7%. [...] > > The theory online was that as long as you're reading one page from each disk > track you're going to pay the same seek overhead as reading the entire track. Could one take advantage of this observation in designing the DSM? Instead of a separate bit representing every page, having each bit represent 20 or so pages might be a more useful unit. It sounds like the time spent reading would be similar; while the bitmap would be significantly smaller.
В списке pgsql-hackers по дате отправления: