[postgis-users] Is caching PostGIS database possible

[Stephen Woodbridge]

On 9/1/2014 3:17 PM, 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?

Yes, google: postgresql optimize database size
basically you need to configure postgresql.conf and change the settings.
specifically you'll want to read about shared_buffers and maybe a few 
other options.

But if you make changes to the database it still has to flush them to 
disk, so you can not avoid doing IO in this case.

-Steve