Differences

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

--- scratchpad:random_magic_spells [2018/08/23 11:59] – 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 ======
@@ Line 553: / Line 568: @@
 where
 clones.data=naming.data and
-naming.folder in(select id from reporter.template_folder where owner=10497 and shared and share_with=1) and
+naming.folder in(select id from reporter.template_folder where owner= !!!REPLACE ME WITH OWNER ID!!! and shared and share_with=1) and
 naming.owner=  !!!REPLACE ME WITH OWNER ID!!!
 group by 1