article thumbnail

Using JSONB in PostgreSQL: How to Effectively Store & Index JSON Data in PostgreSQL

Scalegrid

JSONB supports indexing the JSON data, and is very efficient at parsing and querying the JSON data. JSONB storage has some drawbacks vs. traditional columns: PostreSQL does not store column statistics for JSONB columns. JSONB storage results in a larger storage footprint. It is a decomposed binary format to store JSON.

Storage 321
article thumbnail

What is log management? How to tame distributed cloud system complexities

Dynatrace

Log management is an organization’s rules and policies for managing and enabling the creation, transmission, analysis, storage, and other tasks related to IT systems’ and applications’ log data. It involves both the collection and storage of logs, as well as aggregation, analysis, and even the long-term storage and destruction of log data.

Systems 189
Insiders

Sign Up for our Newsletter

This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Trending Sources

article thumbnail

Bootstrap PostgreSQL on Kubernetes

Percona

Create the ConfigMap from 01-demo-init.yaml manifest: The init.sql does the following: Connects to demo - db database Creates schema media for user myuser Creates 2 tables – BLOG and AUTHORS in the schema I’m combining bootstrapping with the user and database creation functionality that the Operator also provides.

Storage 92
article thumbnail

AWS serverless services: Exploring your options

Dynatrace

This means you no longer have to provision, scale, and maintain servers to run your applications, databases, and storage systems. Speed is next; serverless solutions are quick to spin up or down as needed, and there are no delays due to limited storage or resource access. AWS offers four serverless offerings for storage.

article thumbnail

pgBackRest’s Expire and Backup With Custom Lock-Path Files

Percona

pgBackRest is a highly efficient and versatile tool for managing PostgreSQL backups. This issue tends to occur when your backup storage is located offsite, your database is quite large, and the backup process generates a lot of files. This way, they won’t interfere with each other, enabling efficient parallel execution.

article thumbnail

Extend business observability: Extract business events from online databases (Part 2)

Dynatrace

Create an extension to query complex business data Creating an ActiveGate extension with the Dynatrace extension framework is easy; there’s a tutorial on using the ActiveGate Extension SDK that guides you through making an extension to monitor a demo application bundled with the SDK.

Database 274
article thumbnail

Dynatrace adds support for AWS Transit Gateway with VPC Flow Logs

Dynatrace

This new service enhances the user visibility of network details with direct delivery of Flow Logs for Transit Gateway to your desired endpoint via Amazon Simple Storage Service (S3) bucket or Amazon CloudWatch Logs. Automate cloud operations and trigger remediation workflow to enhance efficiency. What is AWS Transit Gateway?

AWS 223