> 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?
> 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
are you saying it will take 3 seconds surely if i have 50 lakh record
In response to
pgsql-performance by date
|Next:||From: Jurgen Haan||Date: 2008-03-25 13:33:23|
|Subject: Re: PostgreSQL NetApp and NFS|
|Previous:||From: Ivan Voras||Date: 2008-03-25 13:16:43|
|Subject: Re: what is the maximum number of rows in a table in postgresql 8.1|