Craig Kerstiens is a product leader at Crunchy Data, specializing in managed Postgres services, distributed databases, and performance optimization. He curates Postgres Weekly, speaks at conferences, and helps enterprises scale and optimize their Postgres deployments.
164 articles from this blog
Microsoft's new Azure Postgres offering goes GA, bringing high availability, compliance, and competition to the managed PostgreSQL market.
A collection of lesser-known but powerful PostgreSQL features and tips shared by the developer community, from data types to performance tricks.
Strategies for creating effective developer marketing content by leveraging internal engineering communications and support insights.
A guide on conducting effective post-incident retrospectives for software teams, focusing on process and improvement.
An overview of the PostgreSQL community structure, including its unique license, core team, and contributor hierarchy.
A developer's personal appreciation letter to PostgreSQL, reflecting on its evolution, robust features, and adaptability over the years.
A guide to monitoring and managing PostgreSQL database connections, including interpreting connection states and using timeouts.
Strategies for performing safe, low-downtime database migrations in PostgreSQL, focusing on adding columns and creating indexes on large tables.
Explains the differences between logical and physical backups in PostgreSQL, covering their use cases, advantages, and trade-offs.
A preview of the 2017 Postgres Open Silicon Valley conference lineup, highlighting key talks on PostgreSQL indexing, scaling, and concurrency.
A guide to using PostgreSQL's built-in time and date functions, including intervals and date_trunc, for efficient time-based data queries and reporting.
An updated overview of PostgreSQL's key features and improvements from the last 5 years, including JSONB, extensions, and logical replication.
A guide to using the JSONB data type in PostgreSQL, covering indexing, querying, and practical examples for storing and searching JSON data.
A guide to lesser-known but useful PostgreSQL features, including psql tips, query watching, and JSONB formatting.
A technical guide on syncing data from a Postgres database to Salesforce, covering data mapping strategies and common integration challenges.
Explains how to use Open DNS as a resilient DNS resolver during major DNS outages, with configuration instructions.
An overview of Postgres Foreign Data Wrappers (FDWs), explaining how to connect and query external data sources directly from PostgreSQL.
A guide for developers on common database mistakes beginners make, including storing images, using limit/offset for pagination, and relying on integer primary keys.
A candid look at the realities of being a Product Manager, emphasizing data gathering, customer interaction, and team dynamics over high-level strategy.
Tips and best practices for writing clean, readable, and maintainable SQL code, including formatting, CTEs, and commenting.
