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¶
indexes¶
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