title: PostgreSQL Table in memory
body: <p>I created a database containing a total of 3 tables for a specific purpose.  The total size of all tables is about 850 MB - very lean... out of which one single table contains about 800 MB (including index) of data and 5 million records (daily addition of about 6000 records).</p>
  
  <p>The system is PG-Windows with 8 GB RAM Windows 7 laptop with SSD.
  I allocated 2048MB as shared_buffers, 256MB as temp_buffers and 128MB as work_mem.
  I execute a single query multiple times against the single table - hoping that the table stays in RAM (hence the above parameters).
  But, although I see a spike in memory usage during execution (by about 200 MB), I do not see memory consumption remaining at at least 500 MB (for the data to stay in memory).  All postgres exe running show 2-6 MB size in task manager. Hence, I suspect the LRU does not keep the data in memory.</p>
  
  <p>Average query execution time is about 2 seconds (very simple single table query)... but I need to get it down to about 10-20 ms or even lesser if possible, purely because there are just too many times, the same is going to be executed and can be achieved only by keeping stuff in memory.
  Any advice?</p>
  
  <p>Regards,
  Kapil</p>