733 results
Dec 2, 2024
AI-powered performance insights for Aiven for PostgreSQL
Aiven's AI Insights feature for Aiven for PostgreSQL® monitors database performance to identify slow queries. It delivers actionable insights and optimization recommendations, including query rewrites, index creation or removal suggestions, and more—helping you maintain peak database performance.
Learn more in our documentation.
Nov 27, 2024
Improved
Search and index backpressure now configurable in Aiven for OpenSearch®
Aiven for OpenSearch now supports configuring search backpressure and index backpressure settings. These settings optimize resource usage and improve search and indexing performance. You can configure them in the Advanced configurations section of the Aiven Console.
For more information, see Advanced parameters.
Nov 27, 2024
New
Aiven for Apache Kafka® Connect
ClickHouse sink connector now available for Aiven for Apache Kafka Connect®
Aiven for Apache Kafka Connect supports the ClickHouse sink connector. This connector ensures exactly-once semantics for reliable data delivery to ClickHouse. For more information, see Create a ClickHouse sink connector for Aiven for Apache Kafka®
Nov 21, 2024
New
Aiven Operator for Kubernetes
Flink and autoscaler now supported in Aiven Operator for Kubernetes
Aiven for Apache Flink® is supported in version 0.26.0. Support for the autoscaler service integration was also added with the ServiceIntegration field autoscaler and ServiceIntegrationEndpoint field autoscaler.
Other additions in this release include:
userConfig.recovery_basebackup_name for the backup to restore in a forked service.userConfig.auth_generic_oauth.use_refresh_token to refresh tokens and check access token expiration.userConfig.schema_registry_config.retriable_errors_silenced to silence errors that can be retried or custom errors you specify. userConfig.schema_registry_config.schema_reader_strict_mode to configure the Karapace schema-registry service to shutdown when there are invalid schema records in the _schemas topic.userConfig.azure_migration.indices, userConfig.gcs_migration.indices, and userConfig.s3_migration.indices to define a list of indices to restore from the snapshot. Multi-index syntax is supported.The following are deprecated:
userConfig.additional_backup_regionsuserConfig.alerting_enabledFor a full list of the changes and deprecations, check out the Aiven Operator changelog.
Nov 18, 2024
New
Aiven for Apache Kafka® Connect
Aiven for Apache Kafka Connect® now supports Debezium with mTLS for PostgreSQL
Aiven for Apache Kafka Connect supports secure PostgreSQL integration using the Debezium connector with mutual TLS (mTLS). This connector, now generally available, enhances security through mutual authentication between the client and server.
To learn more, see Integrate Apache Kafka Connect with PostgreSQL using Debezium and mutual TLS.
Nov 14, 2024
Improved
TimescaleDB extension 2.17.2 for Aiven for PostgreSQL® released
TimescaleDB extension version 2.17.2 is now available for Aiven for PostgreSQL®. It introduces bug fixes on top of release 2.17.1. Upgrade to 2.17.2 at your earliest convenience to make sure you use the most robust and secure version available.
Refer to TimescaleDB release notes for all the changes introduced in this release.
Bug fixes
Nov 14, 2024
New
Aiven Terraform provider
Autoscaler now supported in Aiven Provider for Terraform
The autoscaler service integration is supported in version 4.29.0 of Aiven Provider for Terraform including the latest configuration options for services, integrations, and endpoints.
Additionally, starting with this release, the changelog will now highlight every schema change. This should make it easier to track and understand the updates Aiven is delivering with the Terraform provider.
For more information on Aiven Provider for Terraform, view the documentation.
Oct 31, 2024
Improved
Aiven CLI
Aiven CLI version 4.4.0 now available
A new minor version of the Aiven CLI has been released to support the following:
avn byoc tags listavn byoc tags update --add-tag KEY=VALUE --remove-tag KEYavn byoc tags replace --tag KEY=VALUEThese tags are attached to BYOC environments and cascaded to bastion nodes in private deployment models.
For more information, see Aiven CLI release notes.
Oct 30, 2024
Improved
TimescaleDB extension 2.17.1 for Aiven for PostgreSQL® released
TimescaleDB extension version 2.17.1 is now available for Aiven for PostgreSQL®. It introduces new features, performance improvements, and bug fixes on top of release 2.16.1. Upgrade to 2.17.1 at your earliest convenience to make sure you use the most robust and secure version available.
Refer to TimescaleDB release notes for all the changes introduced in this release.
Key new features
merge instead of deleting old materialized data and re-inserting. This update can decrease dramatically the amount of data that must be written on the continuous aggregate in the presence of a small number of changes, reduce the i/o cost of refreshing a continuous aggregate, and generate fewer Write-Ahead Logs (WAL). Overall, continuous aggregate policies will be more lightweight, use less system resources, and complete faster.SIMD) vectorization optimization to our engine by supporting vectorized execution for queries that group by using the segment_by column(s) and aggregate using the basic aggregate functions (sum, count, avg, min, max)segment_by columns)PostgreSQL 14 deprecation announcement
PostgreSQL 14 will be supported until April 2025. Closer to that time, there will be an announcement of the specific version of TimescaleDB in which PostgreSQL 14 support will not be included going forward.
New features
merge statement on continuous aggregates refresh.sum(int4) with grouping on segment by columns.decompress_batches_scan functions for easier maintenance.osm chunk.returning clause for merge.min, max, sum, avg, stddev, variance for compressed columns of arithmetic types, when there is grouping on segment by columns or no grouping.Bug fixes
compressed_data_info function.segment by and order by checks when dropping a column from a compressed hypertable.apt and rpm loader packages.compression_chunk_size catalog table.osm chunk.pg_config command executed by cmake to avoid the unexpected building errors.