Re: Index Scans become Seq Scans after VACUUM ANALYSE

Поиск
Список
Период
Сортировка
От Michael Loftis
Тема Re: Index Scans become Seq Scans after VACUUM ANALYSE
Дата
Msg-id 3CBEEFFD.2070905@wgops.com
обсуждение исходный текст
Ответ на Re: Index Scans become Seq Scans after VACUUM ANALYSE  (Bruce Momjian <pgman@candle.pha.pa.us>)
Список pgsql-hackers
Numbers being run on a BSD box now...

FreeBSD 4.3-p27 512MB RAM 2xPiii600 Xeon ona  4 disk RAID 5 ARRAY on a 
dedicated ICP Vortex card.  Sorry no single drives on this box, I have 
an outboard Silicon Gear Mercury on a motherboard based Adaptec 
controller I can test as well.  I'll post when the tests on the Vortex 
are done.  I'm using 2Gb files ATM, I'll look at the code and see if it 
can be made to work with large files.  Atleast for FreeBSD the change 
will be mostly taking doing s/fseek/fseeko/g s/size_t/off_t/g or 
something similar.  FreeBSD seems ot prefer teh Open Unix standard in 
this regard...

This will make it usable for much larger test files.

Tom Lane wrote:

>Michael Loftis <mloftis@wgops.com> writes:
>
>>Somethings wrong with the random numbers from the sun... re-run them, 
>>that first sample is insane....  Caching looks like it's affecctign your 
>>results alot...
>>
>
>Yeah; it looks like the test case is not large enough to swamp out
>caching effects on the Sun box.  It is on the Linux box, evidently,
>since the 10:1 ratio appears very repeatable.
>
>            regards, tom lane
>




В списке pgsql-hackers по дате отправления:

Предыдущее
От: Dav Coleman
Дата:
Сообщение: Re: [SQL] SQL Query Optimization
Следующее
От: Manuel Sugawara
Дата:
Сообщение: Re: regexp character class locale awareness patch