[postgis-users] Is caching PostGIS database possible

[Sandro Santilli]

On Mon, Sep 01, 2014 at 10:17:58PM +0300, Ceyhun Ganioglu wrote:
> Hi,
> 
> Is it possible to cache a whole PostGIS database? For example:
> 
> If a whole database is around 7 GB and the server has 24 GB average
> available RAM. Is it possible to cache all database to RAM and query
> the GIS records from RAM instead of disk?

You could use a RAM disk to store the data.
In that case you'd better do that only for a slave db, so that your data
is not lost on rebooting the machine...

--strk; 

 ()  ASCII ribbon campaign  --  Keep it simple !
 /\  http://strk.keybit.net/rants/ascii_mails.txt