PostgreSQL
PostgreSQL Caching: The Postmaster Process
PostgreSQL
PostgreSQL + TimescaleDB: 1000x Faster Queries, 90% Data Compression, and Much More
TimescaleDB expands PostgreSQL query performance by 1000x, reduces storage utilization by 90%, and provides time-saving features for time-series and analytical applications—while still being 100% Postgres.
PostgreSQL
What Does a PostgreSQL Commitfest Manager Do and Should You Become One?
Having been a PostgreSQL Commitfest Manager earlier this year, Timescaler and PostgreSQL contributor, Jacob Champion, shares his recommendations for those who would like to take on the same role and explains what it entails.
PostgreSQL
What PostgreSQL Contributor Heikki Linnakangas Has to Say About the State of PostgreSQL 2022
PostgreSQL celebrates its 25th birthday this year. For a deeper look into its community, we asked PostgreSQL developer and committer Heikki Linnakangas to comment on the survey results of the newly released State of PostgreSQL 2022 report. Here’s what he had to say.
PostgreSQL
State of PostgreSQL 2022—13 Tools That Aren't psql
Performance and tooling are frequently debated in the State of PostgreSQL survey, and this year was no exception. With psql remaining the number one tool for querying and admin among PostgreSQL users, we decided to compile a list of tools— that aren’t psql—to broaden your options.
PostgreSQL
How PostgreSQL Views and Materialized Views Work and How They Influenced TimescaleDB Continuous Aggregates
Continuous aggregates are one of the most popular features in TimescaleDB, but you can’t fully understand them without some context on PostgreSQL views and materialized views. In this blog post, we’re filling that gap and sharing how views and materialized views influenced continuous aggregates.
PostgreSQL
State of PostgreSQL: How to Contribute to PostgreSQL and the Community
Community contribution remains a recurrent theme in the State of PostgreSQL survey. As we prepare to release the full report later this month, we dig into some of the results and leave you tips on how to contribute to PostgreSQL and its community.
PostgreSQL
What Is SQL Used For? To Build Environments Where Devs Can Experiment
Nikolay Samokhvalov not only solves problems with SQL but also assists others in doing so. In this interview, he shares the coolest thing he did with SQL, how he is building environments where devs can experiment with SQL, and advice on keeping your knowledge up to date.
PostgreSQL
SQL Isn’t That Hard (When You Don’t Approach It From an Object-Oriented Point of View)
John Pruitt first learned SQL at university, but his first interaction with computers dates back to 1986 when he was only four. His one tip for learning SQL? Do not approach it from an object-oriented programming point of view.
PostgreSQL
How to Write Better Queries for Time-Series Data Analysis With Custom SQL Functions
As time-series data becomes more and more ubiquitous, there is a better way to explore it and analyze it with PostgreSQL: hyperfunctions. Learn how to ease your workload with faster and simpler time-series data analysis using TimescaleDB.
Engineering
How We Made Data Aggregation Better and Faster on PostgreSQL With TimescaleDB 2.7
They’re so fast we can’t catch up! Check out our benchmarks with two datasets to learn how we used continuous aggregates to make queries up to 44,000x faster, while requiring 60 % less storage (on average).
PostgreSQL
Analyzing the Bitcoin Blockchain: Looking Behind the Hype With PostgreSQL
Our Bitcoin blockchain data analysis revealed that transaction fees might be on the rise as solutions such as off-chain transactions and scaling transaction batches gain ground. This blog post shows you how we reached these findings— and how to do your own research—using PostgreSQL.
PostgreSQL
SQL Isn't That Hard (When You Learn by Exploration)
To celebrate our love for SQL, we interviewed several of our employees and favorite PostgreSQL community members for this series on how they learned and came to love SQL. Today, we're speaking with Miranda Auhl, who loves finding new ways to visualize data.
PostgreSQL
SQL Isn't That Hard (When You Have a Good Problem to Solve)
To celebrate our love for SQL, we interviewed several of our employees and favorite PostgreSQL community members for this series on how they learned and came to love SQL. Today, we're speaking with David Kohn, an electrochemist turned database enthusiast.
