Skip to main content
thoughtbot thoughtbot
  • Live on Twitch!

    thoughtbot is livestreaming

    Work alongside the thoughtbot team as we collaborate with each other and our clients, live. Ask us anything, we're live right now!

  • Case Studies
  • Blog
  • Let’s Talk
Live on Twitch!

thoughtbot is livestreaming

Work alongside the thoughtbot team as we collaborate with each other and our clients, live. Ask us anything, we're live right now!

Let’s get started!
View all Services
Development
  • Ruby on Rails
  • Hotwire
  • AI and Machine Learning
  • Maintenance
  • Mobile
Design
  • Discovery Sprints
  • UX, UI, and Product Design
  • Design Systems
Product
  • MVP
  • Product Management
  • Accessibility
Team and Processes
  • Team Augmentation
  • Fractional Leadership
View all Services
View all Resources
Development
  • Tech Leadership Resources
  • Open Source
  • Books
  • The Bike Shed Podcast
  • Live Streaming on YouTube
  • Conference Talks
The business of great software
  • Playbook
  • Purpose Built
  • Giant Robots Smashing Into Other Giant Robots Podcast
  • Design Sprint Guide
  • Live Streaming on LinkedIn
View all Resources

PostgreSQL Articles

Written by thoughtbot, your expert partner for design and development.

    • All Topics
    • Design
    • Development
    • Product
    • More topics
  1. Migrating Data from an Upgraded Postgres

    I recently upgraded Postgres on my development machine from 9.1.4 to 9.2.1. ...

    Josh Clayton
    October 16, 2012
    • Web
    • PostgreSQL
  2. Trail Map

    How do I learn Ruby on Rails? Vim? Test-Driven Development? Someone asks...

    Dan Croak
    May 29, 2012
    • News
    • Web
    • Git
    • Ruby
    • Rails
    • PostgreSQL
    • Testing
    • Unix
    • Vim
  3. Global min_messages

    How to reduce postgres output noise.

    Dan Croak
    April 2, 2012
    • Web
    • PostgreSQL
    • Rails
  4. The Durable Document Store You Didn't Know You Had, But Did

    As it turns out, PostgreSQL has a number of ways of storing loosely...

    Harold Giménez
    December 6, 2011
    • Web
    • PostgreSQL
  5. See you at PostgreSQL West

    Come say hi if you are at postgresql west conference.

    Harold Giménez
    September 1, 2011
    • News
    • Web
    • PostgreSQL
  6. How To Back Up A Heroku Production Database To Staging

    Backup a production Heroku Postgres database to a staging environment.

    Dan Croak
    August 18, 2011
    • Web
    • Heroku
    • PostgreSQL
  7. PostgreSQL Conf East

    This following week, PostgreSQL Conf East will take place in New York City....

    Harold Giménez
    March 15, 2011
    • News
    • Web
    • PostgreSQL
  8. PostgreSQL Performance Considerations

    Know the Postgres index types such as multicolumn indexes and partial indexes, don’t over-index, use more joins, prefer INNER JOINs, understand the EXPLAIN output, and don’t try to optimize on your development machine.

    Harold Giménez
    January 7, 2011
    • Web
    • PostgreSQL
    • Performance
  9. Recipe: Ajax Searching And Filtering

    How to use ajax in search and filter features on your web site.

    Dan Croak
    May 19, 2010
    • Web
    • JavaScript
    • PostgreSQL
  10. A Grand Piano for Your Violin

    Thoughts on safe indexes to add to Rails app databases.

    Matt Jankowski
    August 15, 2009
    • Web
    • PostgreSQL
    • SQL
  11. Sign up to receive a weekly recap from thoughtbot

    Looking for even more ways to stay connected?
    RSS feed icon Check out our feeds
« First ‹ Prev 1 2 3 4 5 6 Next › Last »

Footer

thoughtbot
  • Services
  • Case Studies
  • Resources
  • Let's Talk
  • Our Company
  • Careers
  • Purpose
  • Blog
  • Sponsor
  • Mastodon
  • Bluesky
  • GitHub
  • YouTube
  • Twitch
  • Feeds
© 2025 thoughtbot, inc.

The design of a robot and thoughtbot are registered trademarks of thoughtbot, inc.

  • US: +1 (877) 9-ROBOTS
  • UK: +44 (0)20 3807 0560
  • Beware of fraudulent thoughtbot job listings Learn more
  • Code of Conduct
  • Accessibility Statement
  • Privacy Policy