[prev in list] [next in list] [prev in thread] [next in thread] 

List:       postgis-users
Subject:    Re: [postgis-users] Is caching PostGIS database possible
From:       Javier de la Torre <jatorre () vizzuality ! com>
Date:       2014-09-02 8:12:24
Message-ID: A2B1E3C9-9422-4741-AE4B-918CE994A9EF () vizzuality ! com
[Download RAW message or body]

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 <strk@keybit.net> 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
> postgis-users@lists.osgeo.org
> http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
_______________________________________________
postgis-users mailing list
postgis-users@lists.osgeo.org
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users


[prev in list] [next in list] [prev in thread] [next in thread]