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
_______________________________________________
postgis-users mailing list
[email protected]
http://lists.osgeo.org/cgi-bin/mailman/listinfo/postgis-users
