> ## Documentation Index > Fetch the complete documentation index at: https://notes.kodekloud.com/llms.txt > Use this file to discover all available pages before exploring further. # Postgresql on RDS > Overview of PostgreSQL features, extensibility, advanced indexing and data types, and its use on Amazon RDS for scalable, reliable managed deployments. PostgreSQL (often called Postgres) is a mature, open-source relational database management system (RDBMS) designed to handle small to very large workloads. Its combination of advanced features, extensibility, and strong community support makes it a common choice for production systems and managed deployments such as Amazon RDS for PostgreSQL. PostgreSQL shines when you need production-grade reliability, advanced SQL capabilities, and extensibility—especially for applications that rely on complex queries, rich data types, or custom behaviors. Why organizations choose PostgreSQL: * Proven track record in production environments with high reliability and data integrity. * Rich native data types (JSONB, arrays, geometric types) and strong constraint support. * Powerful indexing options and query planner for maintaining performance as data grows. * Extensible architecture (custom types, functions, procedural languages). * Good fit for managed services like [Amazon RDS for PostgreSQL](https://aws.amazon.com/rds/postgresql/). Key strengths | Strength | What it provides | Example use case | | ----------------------------- | -----------------------------------------------------------------------------------: | ---------------------------------------------------------------------- | | Feature-rich relational model | Advanced data types and robust transactional semantics | Storing JSON documents in `JSONB` while enforcing relational integrity | | Powerful indexing | Multiple index types (B-tree, GiST, GIN, BRIN) for varied query patterns | Full-text search with GIN indexes; spatial queries with GiST | | Advanced query planner | Cost-based optimization and sophisticated join strategies | Optimizing complex analytics and reporting queries | | Extensibility | Custom types, operators, extensions (PostGIS, pg\_partman), and procedural languages | Geospatial applications with PostGIS or custom aggregates | | Scalability & reliability | Replication, partitioning, and compatibility with managed services | Read replicas on RDS, partitioned tables for time-series data | A four-panel slide highlighting PostgreSQL use-cases and benefits: feature-rich open-source relational DB, powerful indexing for complex queries, and prioritizing flexibility and extensibility. The rightmost panel lists notable AWS RDS PostgreSQL customers like Atlassian, Blackboard, and Amazon. Detailed notes on core features * Feature-rich data model * Native support for rich data types (JSONB, arrays, hstore, range types, geometric types). * Strong constraint mechanisms (CHECK, UNIQUE, FOREIGN KEY) and full ACID compliance for transactional integrity. * Useful when mixing document-like payloads and relational data—common in modern web and analytics apps. * See: [PostgreSQL Data Types](https://www.postgresql.org/docs/current/datatype.html) * Indexing and performance * A variety of index types: B-tree for general use, GIN for JSONB/full-text, GiST for spatial/indexable searches, BRIN for very large, append-only tables. * Index selection and careful schema design directly affect query performance at scale. * See: [PostgreSQL Indexes](https://www.postgresql.org/docs/current/indexes.html) * Extensibility and ecosystem * Installable extensions (PostGIS, pg\_trgm, citext) extend functionality without changing core code. * Ability to implement custom functions in PL/pgSQL, PL/Python, PL/Perl, etc. * Enables domain-specific optimizations and complex business logic inside the database. * Scalability and managed deployments * Horizontal and vertical strategies: partitioning, read replicas, connection pooling. * Managed options such as Amazon RDS provide automated backups, patching, and simplified replica management. * See: [Amazon RDS for PostgreSQL](https://aws.amazon.com/rds/postgresql/) Choose PostgreSQL when your application needs robust relational features, flexible data modeling (including JSONB), advanced indexing, and the option to extend behavior with custom types or extensions. It's particularly well-suited for analytics, geospatial systems, and applications requiring complex queries. In summary PostgreSQL is a versatile, extensible RDBMS ideal for projects that require advanced query capabilities, diverse data types, and proven production reliability. When paired with managed services like Amazon RDS, it offers a balance of operational convenience and powerful database features—making it a strong candidate for many production workloads. Links and references * [PostgreSQL Official Documentation](https://www.postgresql.org/docs/) * [Amazon RDS for PostgreSQL](https://aws.amazon.com/rds/postgresql/) * [PostGIS (Geospatial extension)](https://postgis.net/) * [JSONB in PostgreSQL](https://www.postgresql.org/docs/current/datatype-json.html)