public inbox for [email protected]  

help / color / mirror / Atom feed

From: Toshiba via PostgreSQL Announce <[email protected]>
To: PostgreSQL Announce <[email protected]>
Subject: InfluxDB FDW 2.1.0 release
Date: Tue, 09 Jan 2024 14:26:13 +0000
Message-ID: <[email protected]> (raw)

InfluxDB FDW 2.1.0 released

We have just released version 2.1.0 of the Foreign Data Wrapper for InfluxDB. This release can work with PostgreSQL 12, 13, 14, 15 and 16.

This release improves following item (from 2.0.0): 

- Support PostgreSQL 16.0 
- Bug fix: Cannot delete when time series column defined as timestamptz type

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 the data file without changing the table definition by using jsonb typed column.


Limitations :

- UPDATE is not supported.
- WITH CHECK OPTION constraints is not supported. Following limitations originate from data model and query language of InfluxDB.
- Result sets have different number of rows depending on specified target list. For example, SELECT field1 FROM t1 and SELECT field2 FROM t1 returns different number of rows if the number of points with field1 and field2 are different in InfluxDB database.
- Timestamp precision may be lost because timestamp resolution of PostgreSQL is microseconds while that of InfluxDB is nanoseconds.
- Conditions like WHERE time + interval '1 day' < now() do not work. Please use WHERE time < now() - interval '1 day'.

This is developed by Toshiba Digital Innovation Technology Center. 
Please see the repository for details.
Source repository : [https://github.com/pgspider/influxdb_fdw](https://github.com/pgspider/influxdb_fdw)

reply

Reply instructions:

You may reply publicly to this message via plain-text email
using any one of the following methods:

* Reply to all the recipients using the --to and --cc options:
  reply via email

  To: [email protected]
  Cc: [email protected], [email protected]
  Subject: Re: InfluxDB FDW 2.1.0 release
  In-Reply-To: <[email protected]>

* Save the following mbox file, import it into your mail client,
  and reply-to-all from there: mbox

This inbox is served by agora; see mirroring instructions
for how to clone and mirror all data and code used for this inbox