Chapter 3Building a Performance-Testing Database
In the previous chapter, you started working with PostgreSQL using psql. You learned about the Rideshare application, connected it to PostgreSQL, and are now ready to work with the application codebase and databases.
In this chapter, you’ll learn tactics that you can use to create a scrubbed copy of your production database. By scrubbing the data, you’ll remove sensitive column values and make the database safe to use for a wide audience where performance testing can be done.
The benefits of performance testing in a separate scrubbed database are that you can test large-scale changes to queries and indexes while the data remains production-like. Testing in a performance database gets you a close ...
Get High Performance PostgreSQL for Rails now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
