PostgreSQL Database Design Best Practices

Good database design is essential to building scalable, high-performance applications. Not only does it help maintain data consistency and accuracy while increasing reliability, it also makes the database easier to use and maintain.

Join Jobin Augustine, PostgreSQL Escalation Specialist at Percona, as he discusses database design best practices and how to avoid common mistakes like:

  • Poor selection of data types
  • Underestimating the impact of unused indexes
  • Default assumptions
  • …and more!

About the Author

Jobin Augustine

I have been supporting various database systems for the last 17 years. I am an active member of the PostgreSQL community in India and participated as speaker and trainer in last pgConf India. I was working as an Architect in OpenSCG for the last couple of years which was taken over by Amazon recently. I was actively involved in the opensource project BigSQL-A PostgreSQL distribution to make PostgreSQL more developer friendly. I´m enthusiastic about joining this team and a great Open Source company.

Subscribe to the
Percona Newsletter

Subscribe Now!

From August 2, 2021, you will no longer be able to purchase Percona’s market-leading database Support as a per month/per server subscription through the online store. For guidance on Percona Support options, including how much you can save with an annual contract, please contact us directly.

Far
Enough.

Said no pioneer ever.
MySQL, PostgreSQL, InnoDB, MariaDB, MongoDB and Kubernetes are trademarks for their respective owners.
© 2026 Percona All Rights Reserved