Changes between Version 2 and Version 3 of members/GRIP-UQAM/Postgres

Timestamp:

Mar 3, 2019, 7:44:29 PM (5 years ago)

Author:

Grip Uqam

Comment:

--

members/GRIP-UQAM/Postgres

@@ -1 +1 @@
 [[PageOutline]]
 = Some PostgreSQL commands =
+* Server version
+{{{#!sh
+$ psql -c 'SELECT version();'
+}}}
 * List of DB with parameters
 {{{#!sh
@@ -36 +40 @@
 {{{#!sql
 ALTER TABLE name SET UNLOGGED;
+}}}
+{{{#!sql
+\dt+ cachetags
+\dt+ cache_*
+select relpersistence, relname from pg_class where relname like 'cache_%';
+}}}
+{{{#!sql
+\db
+SELECT spcname FROM pg_tablespace;
 }}}
   * http://www.postgresql.org/docs/current/static/sql-altertable.html
@@ -145 +158 @@
 * nardberjean: dkg: with d8 being very intense on cache, it makes it more an issue
 2016-08-04
+
+* [*Understanding caching in Postgres - An in-depth guide*](https://madusudanan.com/blog/understanding-postgres-caching-in-depth/)
+* [*PostgreSQL 9.4 in RAM HOWTO*](https://www.manniwood.com/postgresql_94_in_ram/index.html)
+* [*Tablespaces*](https://www.postgresql.org/docs/11/manage-ag-tablespaces.html)
+* [*Prioritizing databases by separating into multiple clusters*](https://wiki.postgresql.org/wiki/Prioritizing_databases_by_separating_into_multiple_clusters)
+* [*Performance Optimization*](https://wiki.postgresql.org/wiki/Performance_Optimization)