13 Tips to Improve PostgreSQL Insert Performance

1. TimescaleDB

   1 103 18,899 9.8 C

   A time-series database for high-performance real-time analytics packaged as a Postgres extension

   

   In Timescale, we have a lot of experience optimizing database performance, so in this article, we will look at PostgreSQL inserts and how to improve their performance. We'll include the following:

2. InfluxDB

   influxdata.com featured

   InfluxDB high-performance time series database. Collect, organize, and act on massive volumes of high-resolution data to power real-time intelligent systems.

   

3. timescaledb-parallel-copy

   2 3 396 8.6 Go

   A binary for parallel copying of CSV data into a TimescaleDB hypertable

   

   For help with bulk loading large CSV files in parallel, check out TimescaleDB's parallel copy command.

4. timescaledb-tune

   3 3 466 5.2 Go

   A tool for tuning TimescaleDB for better performance by adjusting settings to match your system's CPU and memory resources.

   

   We typically recommend 25 % of available RAM. If you install TimescaleDB via a method that runs timescaledb-tune, it should automatically configure shared_buffers to something well-suited to your hardware specs.

5. tsbs

   4 80 1,355 0.9 Go

   Time Series Benchmark Suite, a tool for comparing and evaluating databases for time series data

   

   The overhead from inserting a wide row (say, 50, 100, 250 columns) is going to be much higher than inserting a narrower row (more network I/O, more parsing and data processing, larger writes to WAL, etc.). Most of our published benchmarks are using TSBS, which uses 12 columns per row. So you'll correspondingly see lower insert rates if you have very wide rows.

Suggest a related project