postgresql

administration

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

performance

• tuning postgresql for performance
• slow postgresql performance? don't forget to vacuum your database
• performance tuning postgresql
• faster json generation using postgresql json function | bigbinary blog

queries

• show database, table and indexes size on postgresql

indexes

• indexing for full text search in postgresql

tools

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