article thumbnail

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

Scalegrid

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. JSONB storage does not deduplicate the key names in the JSON. If that doesn’t work, the data is moved to out-of-line storage.

Storage 321
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 97
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

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

Percona

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. Combined, these factors can make the “expire” step take a long time to finish, disrupting your backup schedule and causing conflicts with new backups.

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

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 183
article thumbnail

Dynatrace achieves AWS Outposts Ready designation

Dynatrace

AWS Outposts provides fully managed and configurable compute and storage racks that bring native AWS services, infrastructure, and operating models to any data center or on-premises facility, allowing customers to run computing and storage virtually anywhere while seamlessly connecting to the broad array of AWS services in the cloud.

AWS 198
article thumbnail

Observability engineering: Getting Prometheus metrics right for Kubernetes with Dynatrace and Kepler

Dynatrace

But often, we use additional services and solutions within our environment for backups, storage, networking, and more. Our goal was to filter for metrics that deliver the data we need while minimizing storage costs. This covers the infrastructure, processes, and the application stack, including tracing, profiling, and logs.

Metrics 175