Aaron Parecki

#postgres

• Monitoring CPU and memory usage from Postgres

  Let's say you have a cluster of Postgres database servers and you want a way to easily monitor their CPU and memory usage. You could install any of the system monitoring daemons like Nagios, Collectd, Munin, etc, but that means opening up another port in your firewall, and maintaning another running process. If all you're after is basic info like CPU and memory usage, there's an easier way!

  continue reading...

  1 mention

  #postgres #ops #linux

  Thu, Feb 19, 2015 12:30pm -08:00
• Don't use Postgres's currval() - Wordeology (wordeology.com)

  #postgres

  Fri, Feb 6, 2015 4:38pm -08:00
• pgcli (pgcli.com)

  Pgcli is a command line interface for Postgres with auto-completion and syntax highlighting.

  #postgres #resources #linux #database

  Tue, Jan 6, 2015 3:10pm -08:00
• torodb/torodb (github.com)

  ToroDB is an open source, document-oriented, JSON database that runs on top of PostgreSQL.... It speaks natively the MongoDB protocol, meaning that it can be used with any mongo-compatible client.

  #postgres #mongodb #database #db

  Wed, Oct 29, 2014 8:46am -07:00
• Querying Time Series in Postgresql (no0p.github.io)

  #postgres #stats

  Wed, May 28, 2014 7:56am -07:00
• Simple API with Nginx and PostgreSQL (rny.io)

  #api #nginx #postgres

  Fri, Jul 26, 2013 10:11am -07:00
• Converting MySQL to PostgreSQL (en.wikibooks.org)

  #convert #database #mysql #postgres #tips #tutorial

  Sun, Feb 10, 2013 3:17pm -08:00
• Taps for Easy Database Transfers (adam.heroku.com)

  #database #mysql #postgres #sqlite #taps #tools #utilities

  Sun, Feb 10, 2013 3:16pm -08:00
• Stupid PostgreSQL Tricks: Writable Views (legitimatesounding.com)

  #database #db #postgres

  Tue, Oct 16, 2012 4:13pm -07:00
• Window Functions (www.postgresql.org)

  #database #documentation #postgres #sql #tutorial

  Sat, Aug 25, 2012 9:56am -07:00
• PostgreSQL when it is not your job (reinout.vanrees.org)

  #database #db #postgres #servers #sysadmin #tips

  Wed, Jun 6, 2012 10:17am -07:00