Re: Multiple Indexing, performance impact

> Holy ultra-violet-active macaronies :)
>
> First I changed it to 256, then I changed it to 1024.
>
> -B 128 is A
> -B 256 is B
> -B 1024 is C
>
> New multiple-index performance data):
>
> 1. A: 36 B: 32 C: 35
> 2. A: 69 B: 53 C: 38
> 3. A: 97 B: 79 C: 40
> 4. A: 131 B: 98 C: 48
> 5. A: 163 B: 124 C: 52
> 6. A: 210 B: 146 C: 66
> 7. A: 319 B: 233 C: 149
> 8. A: 572 B: 438 C: 268
> 9. A: 831 B: 655 C:
> 10. A: 1219 B: 896 C:
>
> The last test hasn't finished yet, but THANKS! I know the reson now, at
> least... i'll try
> 2048 also.

Strange that even at 1024 performance still drops off at 7. Seems it
may be more than buffer thrashing.

> -B equals --brutal-performance ? ;)

See my performance article on techdocs.postgresql.org.

--
Bruce Momjian | http://candle.pha.pa.us
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026