PostgreSQL, Blog

5 Common Connection Errors in PostgreSQL and How to Solve Them

25 Apr 2024 4 min read

Tired of running into the same connection errors in PostgreSQL? In this blog post, we tackle the most common and show you how to fix them.

10 psql Commands That Will Make Your Life Easier

19 Apr 2024 4 min read

psql is one of the most popular tools to interact with your PostgreSQL database. Here are our top 10 psql commands to save you time.

How Timescale Replication Works: Enabling HA in PostgreSQL

16 Apr 2024 15 min read

Timescale supports database replication through read replicas. Learn how they work under the hood and how you can enable them.

Time-Series Forecasting With TimescaleDB and Prophet

9 Apr 2024 8 min read

A tutorial on how to use TimescaleDB and Prophet for time-series forecasting and efficient data analysis.

Solving the Challenges of Counter Metrics and Resets in PostgreSQL/TimescaleDB

26 Mar 2024 5 min read

Learn how to solve the challenges of counter metrics, such as counter resets and gaps, in your time-series data using PostgreSQL/TimescaleDB.

Data Visualization in PostgreSQL With Apache Superset

21 Mar 2024 9 min read

Looking for data visualization tools for PostgreSQL? We discuss a few options and provide a step-by-step guide on PostgreSQL and Apache Superset.

How We Made Real-Time Data Aggregation in Postgres Faster by 50,000%

20 Mar 2024 14 min read

Learn how we accelerated real-time data aggregation in PostgreSQL by 50,000 % by tweaking the query planner.

Connecting to Postgres With psql and .pg_service.conf

9 Feb 2024 2 min read

Forgot how to connect to your Postgres services? You can use the .pg_service.conf file, or if you're a Timescale user, just click one button.

Migrating a Terabyte-Scale PostgreSQL Database to Timescale With (Almost) Zero Downtime

29 Jan 2024 14 min read

Introducing a new way to migrate your multi-terabyte PostgreSQL database to Timescale with (almost) zero downtime—live migrations.

PostgreSQL vs MySQL: Which to Choose and When

4 Jan 2024 8 min read

Comparing the strengths and weaknesses of PostgreSQL and MySQL.

A Sneak Peek Into the State of PostgreSQL 2023

11 Dec 2023 6 min read

Enjoy a sneak peek of our State of PostgreSQL 2023 survey, including demographics, favorite PostgreSQL extensions, and the community’s stance on AI.

How to Get Faster Aggregated Data in PostgreSQL

6 Dec 2023 12 min read

There are many ways to retrieve data aggregations, but not all will give you the speed and convenience you’re looking for—cue in continuous aggregates.

Compression Faceoff: Postgres TOAST vs Timescale Compression

29 Nov 2023 10 min read

PostgreSQL TOAST vs. Timescale compression: read the comparison and learn why TOAST is not the most effective database compression mechanism.

Building Columnar Compression for Large PostgreSQL Databases

14 Nov 2023 24 min read

Read how we built a flexible, high-performance columnar compression mechanism for PostgreSQL to add scalability to our favorite database.

Scaling PostgreSQL for Cheap: Introducing Tiered Storage in Timescale

13 Nov 2023 13 min read

Data management decisions don’t have to be costly. Introducing Tiered Storage, a low-cost infinite storage tier for your historical data needs.

Navigating a Usage-Based Model for PostgreSQL: Tips to Reduce Your Database Size

7 Nov 2023 11 min read

Usage-based models demand higher accountability for how you manage your data. Learn tips to reduce your Postgres database size.

Building Blockchain Apps on Postgres

16 Oct 2023 11 min read

Tips and strategies for building blockchain apps on Postgres.

Pgai on Timescale x LlamaIndex: Making PostgreSQL a Better Vector Database for AI Applications

13 Oct 2023 13 min read

Build better AI applications with PostgreSQL as your vector database with pgai on Timescale’s new LlamaIndex integration.

A Python Library for Using PostgreSQL as a Vector Database in AI Applications

28 Sep 2023 9 min read

Seamlessly integrate PostgreSQL as your vector database into Python generative AI, RAG, or chatbot applications.

Visualizing IoT Data at Scale With Hopara and TimescaleDB

18 May 2023 8 min read

Join PostgreSQL pioneer and Turing Award winner, Michael Stonebraker, as he explains one of the many ways his data visualization company, Hopara, extracts meaningful insights from customer data using TimescaleDB.

PostgreSQL, the Time-Series Database You Want

23 Mar 2023 1 min read

Watch a talk about the many approaches to storing time-series data in PostgreSQL at this year’s edition of Jfokus.

12 Days of PostgreSQL Tools and Projects

20 Dec 2022 3 min read

Developers are busy creatures who don’t always have the time to find helpful, productive tools for PostgreSQL. So, even if you don’t celebrate Christmas, we have a little present up our sleeve: 12 Days of PostgreSQL, a.k.a. 12 PostgreSQL projects you should know. Enjoy!

Why PostgreSQL Is the Bedrock for the Future of Data