> partsi wrote:
>>
>> For these kinds of needs, it would be good to support pure in-memory
>> based temporary tables. Even though forced writes are off for global
>> temporary tables and there is a fast cleanup mechanism for their
>> contents, doing these things purely in memory would be the best
>> choice.
>
> Currently, temporary tables rely on the operating system keeping their
> contents in the file cache and not flushing to disk as long as the
> available cache size allows that. IMO, this is more clever than
> implement pure in-memory tables and hope that nobody will cause that

You forget to confirm that "cleanup mechanism for their contents" is
fast, at least it is much faster then "cleanup mechanism" for permanent
table's :)

Regards,
Vlad