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


Ignore:
Timestamp:
Mar 3, 2019, 7:44:29 PM (6 years ago)
Author:
Grip Uqam
Comment:

--

Legend:

Unmodified
Added
Removed
Modified

  • members/GRIP-UQAM/Postgres

    v2 v3  
    11[[PageOutline]]
    22= Some PostgreSQL commands =
     3* Server version
     4{{{#!sh
     5$ psql -c 'SELECT version();'
     6}}}
    37* List of DB with parameters
    48{{{#!sh
    … …  
    3640{{{#!sql
    3741ALTER TABLE name SET UNLOGGED;
     42}}}
     43{{{#!sql
     44\dt+ cachetags
     45\dt+ cache_*
     46select relpersistence, relname from pg_class where relname like 'cache_%';
     47}}}
     48{{{#!sql
     49\db
     50SELECT spcname FROM pg_tablespace;
    3851}}}
    3952  * http://www.postgresql.org/docs/current/static/sql-altertable.html
    … …  
    145158* nardberjean: dkg: with d8 being very intense on cache, it makes it more an issue
    1461592016-08-04
     160
     161* [*Understanding caching in Postgres - An in-depth guide*](https://madusudanan.com/blog/understanding-postgres-caching-in-depth/)
     162* [*PostgreSQL 9.4 in RAM HOWTO*](https://www.manniwood.com/postgresql_94_in_ram/index.html)
     163* [*Tablespaces*](https://www.postgresql.org/docs/11/manage-ag-tablespaces.html)
     164* [*Prioritizing databases by separating into multiple clusters*](https://wiki.postgresql.org/wiki/Prioritizing_databases_by_separating_into_multiple_clusters)
     165* [*Performance Optimization*](https://wiki.postgresql.org/wiki/Performance_Optimization)