Postgres Weekly Issue 4
April 3, 2013
Extra Security Measures for Next Week's PostgreSQL Releases
Tom Lane, heavy contributor and Postgres core member, describes the GitHub repo going private ahead of a release for this Thursday (April 4th). Others have warned of some security issues and all are encouraged to update their installations as early as possible once new versions are released.
PostgreSQL Conference Europe 2013: Dates and Location Announced
PGConf.EU 2013 will be held on Oct 29-Nov 1 at the Conrad Hotel in Dublin, Ireland. The CFP isn't open yet, but you can follow the event's @pgconfeu Twitter handle to stay up to date. We will also be sure to link again in Postgres Weekly too.
Understanding Postgres Data Caching
Postgres is typically very intelligent and efficient at caching frequently accessed data automatically. Heroku provides a good overview here that digs into how Postgres' caching actually works.
Postgres Search using pg_search
Postgres has powerful and flexible full-text search built in. However you don't need to learn the full inner workings to take advantage – instead Isotope 11 highlights how to take advantage of it by using the pg_search gem in Ruby.
Range Types in your Application [PDF]
Range types, newly available in Postgres 9.2, are now one of the many types that exist for Postgres. Jeff Davis who was the primary contributor to range types highlights their value and how to use them in these slides.
pg_activity: 'top'-like Activity Monitoring for Postgres
Getting insight into your Postgres database can often be confusing. pg_activity provides top like application for Postgres database monitoring.
PostgreSQL as a Schemaless Database [PDF]
With hStore, JSON and PLV8, theres increasing talk of Postgres' flexibility as a schema-less data store. Christophe of PG Experts walks through how it measures up in performance against MongoDB; in particular giving some recommendations on Postgres index types and characteristics of them.
pg_tail: Like 'tail -f' for your PostgreSQL Tables