Explore >> Select a destination
|
You are here 
|
lantern.dev | ||
| | | | |
shekhargulati.com
|
|
| | | | | In relational database design one of the key decisions is choosing the right primary key type for tables. In this post I am talking about surrogate or synthetic primary keys. They are called surrogate or synthetic as these keys are not derived from application data. In my experience I have seen very few teams giving... | |
| | | | |
stepchange.work
|
|
| | | | | In this post, we explore the limits of single-node Postgres and what optimizations can extend its usefulness as a primary application database before requiring more advanced scaling solutions. Monolithic ecommerce app on RDS PostgreSQL Let's use a real-world scenario, a monolith web application that uses PostgreSQL as the application database running on AWS RDS. The RDS instance is a 2xlarge. The resources are: * 8 vCPUs * 64 GB Memory * 20,000 Max I/O operations per second (IOPS) In ou | |
| | | | |
pganalyze.com
|
|
| | | | | Learn about smaller indexes with B-Tree Deduplication, Extended Statistics Improvements, Parallel VACUUM, improved WAL Usage Stats in Postgres 13, and more. | |
| | | | |
gist.github.com
|
|
| | | Kickstarter Engineering Ladder. GitHub Gist: instantly share code, notes, and snippets. | ||
