Skip to:

  1. Skip to Jira Navigation
  2. Skip to Side Navigation
  3. Skip to Main Content

External PostgreSQL Consultant performing a resilience and reliability test

Description

We want to validate pg_tde with an external PostgreSQL consultant. This way, we get feedback from someone outside of the company but also from someone who is well known in the community and also knows exactly what and how to test.

How to document

None

How to test

None

Smart Checklist

hide

Activity

Show:

Kai Wagner March 19, 2025 at 9:22 AM

The last test run was triggered against Percona Server for PostgreSQL v.17.4.1. This enables us to also compare the segment encryption and to ensure durability.

Kai Wagner February 17, 2025 at 1:13 PM

Issue was addressed now, by setting the hints bits by count(*) before the benchmark run. Without WAL, results look good now, and andreas is currently testing WAL encryption as well. Waiting for the results

Kai Wagner February 10, 2025 at 8:53 AM

Testing is ongoing, and look at https://perconadev.atlassian.net/browse/PG-1243?atlOrigin=eyJpIjoiOWUyZWRhMDY5NzM4NDAwOWJjZTkxMjUzYjM4NzFlNTMiLCJwIjoiaiJ9 for details about the “hint bit” issue, that we’ve found along the way.

Kai Wagner December 12, 2024 at 9:12 AM

Neither nor I were able to reproduce the issues, that Andreas saw. We believe, this is duo to the overall testing noise and differences in each testrun. Running is with a fixed time instead of transactions also produced better, more reliable results. Testing continues now with modified tests from ads

Kai Wagner December 6, 2024 at 8:22 AM

The testing is ongoing, and Andreas has already shared graphs and findings. It seems we do have a threshold issue at a specific client level, that gets way worse, with a larger database.

is looking into it, to see if we can spot the root cause of it.

Details

Assignee

Reporter

Components

Sprint

Priority

Parent

Smart Checklist

Created October 9, 2024 at 7:30 AM
Updated last week