Differences

This shows you the differences between two versions of the page.

--- scratchpad:random_magic_spells [2018/08/23 12:01] – bmagic
+++ scratchpad:random_magic_spells [2022/02/10 13:34] (current) – external edit 127.0.0.1
@@ Line 228: / Line 228: @@
 netscape.security.PrivilegeManager.enablePrivilege("UniversalXPConnect"); JSAN.use('util.file'); var f = new util.file('ws_info'); alert(f._file.path);
 </code>
+====== Performance ======
+=====Preload Your database into RAM=====
+Find your database's oid and make a note of it:
+<code>
+psql -U evergreen -h localhost -d postgres -c "select oid from pg_database where datname = 'evergreen'"
+</code>
+Then, as the root or postgres user, run the following commands
+<code>
+cd /var/lib/postgresql/${pgversion}/main/base/${oid}
+cat * > /dev/null
+</code>
+Replace ${pgversion} with your PostgreSQL version number, ex. 9.5.  Replace ${oid} with the number returned by the database query.
 ====== Utility ======