One possible explanation is that the OS's native file system caching is
being successful at keeping these files mostly in RAM most of the time.
And so the performance benefits of 'forcing' the files into RAM by
using tmpfs aren't significant.
So the slowness of the queries is the result of be
767 MB 76 seconds
(single, local SATA 7200rpm disk, unloaded XServe G5)
Sean Fox
Walter Underwood wrote:
Please answer with the size of your index (post-optimize) and how long
an optimize takes. I'll collect the data and see if I can draw a line
through it.
190 MB, 55 seconds
$ du -sk /apps/