Akshay Mathur wrote:


Can you give me some pointers to make the tables RAM resident. If one
does so, is the program accessing the data need to change. Does pgsql
take care to write the data to disk?

PostgreSQL tried to intelligently cache information and then will also use the OS disk cache as a secondary cache. So a sufficiently small and frequently accessed table will be resident in RAM.

The simplest way to affect this calculus is to put more RAM in the machine. There are hacks I can think of to create RAM caches of specific tables, but I don't want to take responsibility for anyone trying these and running into trouble.

Best Wishes,
Chris Travers
Metatron Technology Consulting

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply via email to