We value your privacy

We use cookies to enhance your browsing experience, serve personalized ads or content, and analyze our traffic. By clicking "Accept All", you consent to our use of cookies.

Customize Consent Preferences

We use cookies to help you navigate efficiently and perform certain functions. You will find detailed information about all cookies under each consent category below.

The cookies that are categorized as "Necessary" are stored on your browser as they are essential for enabling the basic functionalities of the site. ... 

Always Active

Necessary cookies are required to enable the basic features of this site, such as providing secure log-in or adjusting your consent preferences. These cookies do not store any personally identifiable data.

No cookies to display.

Functional cookies help perform certain functionalities like sharing the content of the website on social media platforms, collecting feedback, and other third-party features.

No cookies to display.

Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics such as the number of visitors, bounce rate, traffic source, etc.

No cookies to display.

Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors.

No cookies to display.

Advertisement cookies are used to provide visitors with customized advertisements based on the pages you visited previously and to analyze the effectiveness of the ad campaigns.

No cookies to display.

NewApp Digest
search bot

open source PostgreSQL

PostgreSQL 17 packs big performance and feature enhancements
Tech Optimizer
September 26, 2024

PostgreSQL 17 packs big performance and feature enhancements

PostgreSQL 17 has been released by the PostgreSQL Global Development Group, introducing native support for incremental backups, enhancing SQL/JSON capabilities with new functions, allowing configuration of the Simple Least Recently Used (SLRU) cache, and improving logical replication processes. Performance improvements include better handling of write-ahead log (WAL) locks, optimization of queries using the IN clause with B-tree indexes, and support for Intel AVX-512 chip instructions.
Microsoft backs open source PostgreSQL analytics extension
Tech Optimizer
August 20, 2024

Microsoft backs open source PostgreSQL analytics extension

A Microsoft-backed open source initiative is integrating the in-process OLAP system DuckDB into PostgreSQL to enhance its capabilities as an analytics database. This project, licensed under the MIT License, aims to improve the efficiency of PostgreSQL for analytical purposes, addressing challenges developers face. The intellectual property of the extension is owned by the DuckDB Foundation, and it is hosted in the DuckDB GitHub repository. DuckDB operates as an embedded analytics engine, allowing users to run queries directly on data within the Pandas library without data importation. The new pg_duckdb extension is supported by organizations including DuckDB Labs, Microsoft, Hydra, Neon, and MotherDuck. Historically, developers have attempted to create OLAP versions of PostgreSQL since the early 2000s. DuckDB's optimizer is based on TUM's HyPer optimizer, allowing it to handle complex queries effectively.
Crunchy Data Introduces Postgres Query Engine for Data Lakes, Crunchy Bridge for Analytics
Tech Optimizer
July 6, 2024

Crunchy Data Introduces Postgres Query Engine for Data Lakes, Crunchy Bridge for Analytics

Crunchy Data has introduced Crunchy Bridge for Analytics, a tool within their fully managed cloud Postgres service that allows users to interact with data lakes using PostgreSQL commands. This tool enables users to set up foreign tables linking directly to Parquet, CSV, or JSON files in object storage without specifying columns, enhancing data management and analysis.
Crunchy Data Postgres 16 Security Technical Implementation Guide Released by DISA
Tech Optimizer
July 4, 2024

Crunchy Data Postgres 16 Security Technical Implementation Guide Released by DISA

Crunchy Data has published the Crunchy Data PostgreSQL 16 Security Technical Implementation Guide (STIG) in collaboration with the United States Defense Information Systems Agency (DISA). This guide provides security guidance for the deployment and configuration of Crunchy Certified PostgreSQL, adhering to Department of Defense security requirements.
Search