Thu.Dec 22, 2022

article thumbnail

Hunting for bandwidth on a consumer NVMe drive

n0derunner

The Samsung SSD 970 EVO 500GB claims a sequential read bandwidth of 3400 MB/s this is a story of trying to achieve that number. Starting point We start with a Haswell based PCIE Gen2 machine. First of all write out data across the drive with fio Quick sanity check to ensure we have data on … The post Hunting for bandwidth on a consumer NVMe drive appeared first on n0derunner.

Storage 59
article thumbnail

PostgreSQL Role Inheritance at a Glance

Percona

PostgreSQL manages database access permissions using the concept of roles. A role can be either a database user or a group of database users, depending on how the role is set up. Roles can own the database objects and assign privileges on those objects to other roles to control who has access to which objects. Furthermore, it is possible to grant membership in a role to another role, thus allowing the member role to use privileges assigned to another role.

C++ 75