By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
424,963 Members | 920 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 424,963 IT Pros & Developers. It's quick & easy.

How to make a copy of data in RAM ???

P: 12
Hi All


Can anybody tell me like how to tell make a copy of data into RAM from hard disk for faster accessing of data??

My Postgres database and its contents(databases,tables are sitting in Hard disk) i would like to make copy for table_1 and store it in RAM. How to do that ?
are there any commands for doing that ?


Thanks in Advance
Pradi!
Dec 28 '06 #1
Share this Question
Share on Google+
1 Reply


Expert 100+
P: 534
I don't htink there's a command in Postgresql to force copying a specific table into RAM.
If I remember correctly the last accessed, or the most accessed table is kept in the internal cache anyway.
If you want to farthjer explore cacheing in Postgres look at the effective_cache_size in Postgres documentation, and maybe at memcached software package -
http://www.danga.com/memcached
and Postgres interface to it -
http://people.freebsd.org/~seanc/pgmemcache/

But first make sure that your tables are optimazed (look at the queries you run, look at the table indexes, run explain analyze, etc)
Dec 29 '06 #2

Post your reply

Sign in to post your reply or Sign up for a free account.