Changes between Version 5 and Version 6 of Performance

Timestamp:

Jun 16, 2013, 9:37:58 PM (11 years ago)

Author:

Dimitar Misev

Comment:

—

Performance

@@ -2 +2 @@
 
 = Guidelines =
+
 
 = Benchmarks =
@@ -92 +93 @@
 
  * vacuumdb -d RASBASE -t "pg_largeobject" -f
+
+
+= Tile cache =
+
+A tile cache can be enabled in rasdaman during bulk ingestion, in order to work around inefficiencies of BLOB handling in postgres and slow performance for certain tiling schemes.
+
+'''IMPORTANT:''' At the moment the tile cache should be used during bulk ingestion '''_ONLY_''', and disabled afterwards. Leaving the tile cache on will cause selection queries to fail randomly. Furthermore, it is best to have only one server defined in rasmgr.conf, and `-countdown` and `--timeout` parameters set to very large values.
+
+The cache can be enabled in rasmgr.conf by specifying a `--cachelimit` parameter after the `-xp` parameter:
+{{{
+  --cachelimit <limit>  (default: 0)
+         specifies upper limit in bytes on using memory for caching
+}}}
+
+An example `rasmgr.conf` configuration that allows the cache to use up to 1GB memory:
+{{{
+define dbh rasdaman_host -connect RASBASE
+define db RASBASE -dbh rasdaman_host
+
+define srv N1 -host HOST -type n -port 9000 -dbh rasdaman_host
+change srv N1 -countdown 20000000 -autorestart on -xp --timeout 30000000 --cachelimit 1073741824
+}}}