Want to know if an index will be useful before you create it? Here’s an extension to help with just that, by hypothetically creating an index before it actually writes it out. Great to see if an index will be useful ahead of time!

If you’re doing any level of complex or even moderately complex aggregation across your data, window functions are hugely useful. Here’s an example of how you can use them.

Want your application’s search to be a bit more flexible than perfectly matching what the user entered? Postgres has some built in flexibility for finding ‘similar’ words and sounds.

VividCortex is the easiest, safest, and most detailed way to monitor PostgreSQL. Unlike other tools that just capture a few status metrics, VividCortex measures every query, every process, and every metric on your entire system, down to the microsecond to improve performance.

If you’re using Arrays or other more unique datatypes, the default WHERE when searching isn’t going to be your ideal. Fortunately there is a better option that works great in Postgres, here’s how to take advantage of it in Rails directly.

Parallel ‘psql’. Run parallel queries inline in PostgreSQL’s psql tool. Useful for ‘slightly big data’, GIS.

Holycorn makes it easy to implement a Foreign Data Wrapper for Postgres using Ruby. It’s built on top of mruby.