Luke Lonergan wrote:
> Bruce,
>
> It (the compute intensity optimization) is what we did for copy parsing,
> and it sped up by a factor of 100+.
>
> The rest of the copy path could use some work too.
>
> Yge virtual tuples in 8.1 are another example of grouping operations
> into more compact chunks instead of doing bits at a time.
>
> The l2 cache optimization could pay huge dividends for certain parts
> of the code path, like sorting for instance. A simple outer loop that
> strip mines in l2 sized chunks in sorting could speed things up 5 to
> 10 times in that section.
Yes, I can see COPY and sort being good for optimization because we
spend a large percentage of the command in a small section of the code.
I just don't know what other things have a similar localized operating
area.
-- Bruce Momjian | http://candle.pha.pa.us pgman@candle.pha.pa.us | (610)
359-1001+ If your life is a hard drive, | 13 Roberts Road + Christ can be your backup. | Newtown Square,
Pennsylvania19073