postgresql

administration

• postgresql: table partitioning (opens in a new tab)
• partial index
• pools de conexão e fontes de dado
• stanislaw pusep : making a decent postgresql.conf, like a boss (opens in a new tab)
• agajorte: java, linux, postgresql e gastronomia: mantendo atualizado o índice fts no postgresql
• disk usage - postgresql wiki (opens in a new tab)

performance

• tuning postgresql for performance
• slow postgresql performance? don't forget to vacuum your database (opens in a new tab)
• performance tuning postgresql
• faster json generation using postgresql json function | bigbinary blog (opens in a new tab)

queries

• show database, table and indexes size on postgresql

indexes

• indexing for full text search in postgresql (opens in a new tab)

tools

• psql command line tutorial and cheat sheet | postgres (opens in a new tab)
• pgtune
• step 3: configuring the collector · pganalyze (opens in a new tab)
• shmsetup.sh: calcula as configurações de kernel shared memory (opens in a new tab)
• postgres explain visualizer (pev)
• pg_search: how i learned to stop worrying and love postgresql full-text search | pivotal (opens in a new tab)
• useful postgresql queries and commands (opens in a new tab)
• postgresql: documentation: 9.6: pg_isready (opens in a new tab)