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
Web Development
  • Ruby on Rails
  • Hotwire
  • AI and Machine Learning
  • React
  • Maintenance
Mobile Development
  • React Native
  • iOS
  • Android
Design
  • UX, UI, and Product Design
  • Design Research
  • Design Systems
Product
  • Product Management
  • Product Design Sprint
  • Research and Strategic Insights
  • Accessibility
Team and Processes
  • Team Augmentation
  • Fractional Leadership
  • Level up your junior team
View all Services
View all Resources
Development
  • Tech Leadership Resources
  • Open Source
  • Books
  • The Bike Shed Podcast
  • Live Streaming on YouTube
The business of great software
  • Playbook
  • Startup Incubator
  • Giant Robots Smashing Into Other Giant Robots Podcast
  • Design Sprint Guide
  • Live Streaming on LinkedIn
View all Resources

Postgres Articles

Written by thoughtbot, your expert strategy, design, product management, and development partner.

    • All Topics
    • Design
    • Web
    • iOS
    • Android
    • More topics
  1. 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
    • Postgres
    • Performance
  2. 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
    • Postgres
  3. A Grand Piano for Your Violin

    Thoughts on safe indexes to add to Rails app databases.

    Matt Jankowski
    August 15, 2009
    • Web
    • Postgres
    • SQL
  4. The defest of leppards

    If you have any moderately old rails applications in production, and you find...

    Matt Jankowski
    January 14, 2008
    • Web
    • Rails
    • Postgres
  5. NULLs. Can't Live with 'em Can't Live Without 'em

    Problems with NULL in Rails associations.

    Jared Carroll
    January 18, 2007
    • Web
    • Rails
    • Postgres
  6. Sign up to receive a weekly recap from thoughtbot

« First ‹ Prev 1 2 3 4 5

Footer

thoughtbot
  • Services
  • Case Studies
  • Resources
  • Let's Talk
  • Our Company
  • Careers
  • Purpose
  • Blog
  • Sponsor
  • Mastodon
  • GitHub
  • Instagram
  • YouTube
  • Twitch
© 2024 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