User Tools

Site Tools


wiki:postgres:pg_tune_kurs_pg_contrib

Differences

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

Link to this comparison view

wiki:postgres:pg_tune_kurs_pg_contrib [2017/09/28 12:21] (current)
Line 1: Line 1:
 +====== Tools in CONTRIB ======
  
 +/​usr/​local/​src/​postgresql-9.0.3/​contrib/​
 +
 +===== pgstattuple =====
 +  cd /​usr/​local/​src/​postgresql-9.0.3/​contrib/​
 +  psql test < pgstattuple ​    # Tabelle physikalisch analysieren (Statistiken über "​dead"​ tuples und free space in einer Tabelle).
 +  test=# select * from pgstattuple('​t_test'​);​
 +===== pg_buffercache =====
 +shared_buffer analysieren - was ist drinnen (real time queries on the shared buffer cache).
 +===== pageinspect =====
 +In die Page reinschauen und den binären Kontext ausgeben (allows inspection of database pages).
 +
 +**ENDE EINER SUPER SCHULUNG** LOL
wiki/postgres/pg_tune_kurs_pg_contrib.txt · Last modified: 2017/09/28 12:21 (external edit)