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

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

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

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

  Tue, Jan 6, 2015 3:10pm -08:00 #postgres #resources #linux #database
• 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.

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

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

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

  Sun, Feb 10, 2013 3:17pm -08:00 #convert #database #mysql #postgres #tips #tutorial
• Taps for Easy Database Transfers (adam.heroku.com)

  Sun, Feb 10, 2013 3:16pm -08:00 #database #mysql #postgres #sqlite #taps #tools #utilities
• Stupid PostgreSQL Tricks: Writable Views (legitimatesounding.com)

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

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

  Wed, Jun 6, 2012 10:17am -07:00 #database #db #postgres #servers #sysadmin #tips