PostgreSQL: InfluxDB FDW 2.0.0 released

NewsBot · 28 March 2023 15:05

A new PostgreSQL blog post/announcement has been posted!

We have just released version 2.0.0 of the Foreign Data Wrapper for InfluxDB. This release can work with PostgreSQL 11, 12, 13, 14 and 15. This release improves following item (from 1.2.0):

Support PosgreSQL 15.0

Support InfluxDB v1.x: with pgspider/influxdb-cxx client library.

Support InfluxDB v2.x: with pgspider/influxdb-cxx client library via InfluxDB v1 compatibility API.

The FDW supports following features :

InfluxDB FDW supports pushed down some aggregate functions: count, stddev, sum, max, min.

InfluxDB FDW supports INSERT, DELETE statements.

InfluxDB FDW supports bulk INSERT by using batch_size option from PostgreSQL version 14 or later.

WHERE clauses including timestamp, interval and now() functions are pushed down.

LIMIT...OFFSET clauses are pushed down when there is LIMIT clause only or both LIMIT and OFFSET.

Support schemaless mode that allows access to elements in ...

Get the full details here: PostgreSQL: InfluxDB FDW 2.0.0 released