>
> Yes. It takes your hardware about 3 seconds to read through 700M of ram.
>
>
> Keep in mind that you're not just reading RAM. You're pushing system
> requests through the VFS layer of your operating system, which is treating
> the RAM like a disk (with cylinder groups and inodes and blocks, etc) so
> you have all that processing overhead as well. What filesystem did you
> format the RAM disk with?
>
tmpfs
>
> Why are you doing this? If you have enough RAM to store the table, why
> not just allocate it to shared buffers?
just allocating will make read from hdd to RAM at first time, to eliminate
that
>
>
are you saying it will take 3 seconds surely if i have 50 lakh record