I believe that with the correct PostgreSQL configuration, PostgreSQL will cache the data in ram if it is being used and there is enough space.
I don't think you can force PostgreSQL to read everything and put it in memory, it just happens as it runs. That's why the database seems to be faster after a while running, because PostgreSQL starts caching. > On 02/09/2014, at 10:07, Sandro Santilli <[email protected]> wrote: > >> 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 > _______________________________________________ > postgis-users mailing list > [email protected] > http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users _______________________________________________ postgis-users mailing list [email protected] http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
