[PATCH 2/2] defconfigs: add sysbench PostgreSQL XFS testing fragments

From: Daniel Gomez <[email protected]>

Adds composable defconfig fragments for testing PostgreSQL workloads
with sysbench on XFS with different block sizes (4K and 16K). These
fragments enable testing XFS large block size configurations with
realistic database workloads to measure TPS variability and performance.

The fragments can be combined with workflow-specific and monitoring
configurations using the defconfigs/configs/ pattern.

Generated-by: Claude AI
Signed-off-by: Daniel Gomez <[email protected]>
---
 defconfigs/configs/sysbench-nvme.config             |  3 +++
 .../configs/sysbench-postgresql-xfs-16k.config      |  4 ++++
 .../configs/sysbench-postgresql-xfs-4k.config       |  3 +++
 .../sysbench-postgresql-atomic-tps-variability      | 21 +++++++++++++++++++++
 4 files changed, 31 insertions(+)

diff --git a/defconfigs/configs/sysbench-nvme.config b/defconfigs/configs/sysbench-nvme.config
new file mode 100644
index 00000000..f18e965b
--- /dev/null
+++ b/defconfigs/configs/sysbench-nvme.config
@@ -0,0 +1,3 @@
+CONFIG_LIBVIRT_EXTRA_STORAGE_DRIVE_NVME=y
+CONFIG_SYSBENCH_DEVICE_BASELINE="/dev/disk/by-id/nvme-QEMU_NVMe_Ctrl_kdevops1"
+CONFIG_SYSBENCH_DEVICE_DEV="/dev/disk/by-id/nvme-QEMU_NVMe_Ctrl_kdevops1"
diff --git a/defconfigs/configs/sysbench-postgresql-xfs-16k.config b/defconfigs/configs/sysbench-postgresql-xfs-16k.config
new file mode 100644
index 00000000..858e61e6
--- /dev/null
+++ b/defconfigs/configs/sysbench-postgresql-xfs-16k.config
@@ -0,0 +1,4 @@
+CONFIG_LIBVIRT_EXTRA_STORAGE_DRIVE_NVME=y
+CONFIG_SYSBENCH_FS_XFS=y
+CONFIG_SYSBENCH_XFS_SECTION_REFLINK_16K=y
+CONFIG_SYSBENCH_XFS_SECTOR_SIZE_16K=y
diff --git a/defconfigs/configs/sysbench-postgresql-xfs-4k.config b/defconfigs/configs/sysbench-postgresql-xfs-4k.config
new file mode 100644
index 00000000..aed78d0c
--- /dev/null
+++ b/defconfigs/configs/sysbench-postgresql-xfs-4k.config
@@ -0,0 +1,3 @@
+CONFIG_SYSBENCH_FS_XFS=y
+CONFIG_SYSBENCH_XFS_SECTION_REFLINK_4K=y
+CONFIG_SYSBENCH_XFS_SECTOR_SIZE_4K=y
diff --git a/defconfigs/sysbench-postgresql-atomic-tps-variability b/defconfigs/sysbench-postgresql-atomic-tps-variability
new file mode 100644
index 00000000..54fe3bf3
--- /dev/null
+++ b/defconfigs/sysbench-postgresql-atomic-tps-variability
@@ -0,0 +1,21 @@
+CONFIG_GUESTFS=y
+CONFIG_LIBVIRT=y
+
+CONFIG_WORKFLOWS=y
+CONFIG_WORKFLOW_LINUX_CUSTOM=y
+
+CONFIG_BOOTLINUX=y
+CONFIG_BOOTLINUX_9P=y
+
+CONFIG_WORKFLOWS_TESTS=y
+CONFIG_WORKFLOWS_LINUX_TESTS=y
+CONFIG_WORKFLOWS_DEDICATED_WORKFLOW=y
+CONFIG_KDEVOPS_WORKFLOW_DEDICATE_SYSBENCH=y
+CONFIG_KDEVOPS_WORKFLOW_ENABLE_SYSBENCH=y
+
+CONFIG_SYSBENCH_NATIVE=y
+CONFIG_SYSBENCH_TYPE_POSTGRESQL_NATIVE=y
+CONFIG_SYSBENCH_FS_XFS=y
+CONFIG_SYSBENCH_XFS_SECTOR_SIZE_4K=y
+
+CONFIG_DEVCONFIG_ENABLE_SYSTEMD_JOURNAL_REMOTE=y

-- 
2.51.0