blog.aleph-tech.comAleph Technologies Blog | Applications come and go, data stays.

Aleph Technologies Blog Applications come and go, data stays. Search for: Search for: Toggle navigation IO performance on an ASUS Pro WS WRX80/AMD ThreadRipper server Posted on July 18, 2021 After reading Tanel Poder’s remarkable Achieving 11M IOPS & 66 GB/s IO on a Single ThreadRipper Workstation post, I was very impressed by the IO performance he achieved with NVMe storage. Incidentally, a few weeks after reading this post ASUS started selling the Pro WS WRX80 SAGE motherboard with support for the newest AMD Ryzen ThreadRippr processors and 7 PCIe 4 slots. As we needed to expand our lab datacenter for a number.. Read More Resync postgresql standby with wal-g catchup Posted on February 6, 2021 When a postgresql standby gets out of sync and the replication lag is relatively big, the usual solution is to clone the primary database again, to avoid the slow proess of re-applying all archived WALs that are lagging. However, a complete clone of a large database could be long. As I wondered the other time how I could do the same technique as for Oracle databases: identify the current SCN on the physical.. Read More Postgresql Performance on Ubuntu linux 18.04 and Amazon AWS EC2 iXL instance Posted on January 27, 2020 Introduction This is a follow-up on our Postgresql Performance on Ubuntu 18.04 and Nutanix post. We document here the same pgbench tests on an Amazon EC2 i-XL instance with NVMe SSD storage. Disclaimer The following test results are not intended to give definitive numbers on the tested platform. These are only illustrative of the methodology used to test the platform for postgresql workloads. Sustained database benchmark with different linux kernel parameters We tested.. Read More Postgresql Performance on Ubuntu linux 18.04 and Nutanix Posted on January 26, 2020 Background On november 4, 2019, we were benchmarking a number of virtual machines on a new 12-node DELL 740XD-24 appliance under Nutanix AHV (and RDMA enabled). I was getting weird results and I tweeted the following: At the moment we were configuring both the Nutanix appliance and the Linux kernel parameters most suitable for a postgresql 9.5 specific workload. That was not a good idea and produced confusing test results since the actual.. Read More GDPR article mapping to RDBMs feature availability Posted on May 24, 2018 To close the article series on GDPR and available features in each of the four database systems reviewed, I was made aware by a few acquaintances that a more clear mapping between the actual regulation text and the itentified tasks, along with the features available on each database system would be very helpful. This is the purpose of this article and I hope it will be of help to everyone trying to map.. Read More GDPR demystified – Part 4 : Mysql / MariaDB Posted on May 21, 2018 In the previous posts, we discussed GDPR and how we could enforce it in the scope of Oracle , SQL Server and Postgresql databases. We now cover the same topic with Mysql and Mariadb databases in mind. As always, please refer to GDPR Data Security requirements laid down in the initial post. We will continue to walk the same task and activity structure for all RDBMs we cover. Let’s go to the identified.. Read More GDPR demystified – Part 3 : Postgresql Posted on May 11, 2018 In the previous posts, we discussed GDPR and how we could enforce it in the scope of Oracle and SQL Server databases. We now cover the same topic with Postgresql databases in mind. As always, please refer to GDPR Data Security requirements laid down in the initial post. We will continue to walk the same task and activity structure for all RDBMs we cover. Let’s go to the identified GDPR tasks and requireements.. Read More GDPR demystified – Part 2 : Oracle Posted on May 8, 2018 In the previous post we talked about GDPR and how it could be enforced in the scope of SQL Server databases. We now cover the same topic but with Oracle databases in mind. Please refer to GDPR Data Security requirements as stated in the post. We will religiously walk the same task and activity structure for all RDBMs we cover. Let’s move fast to the identified GDPR tasks and requireements and then the.. Read More GDPR demystified – Part 1 : SQL Server Posted on May 7, 2018 After months (years ?) seeing warnings and calls for attention to companies that are in a way or another impacted by the GDPR regulation and after being asked every now and then the same questions over and over again, I decided to write a few posts covering the technologies that can be used to implement the technical mechanisms required to enforce EU GDPR. I will cover major RDBMS and today we start with.. Read More Improving fuzzy searches in postgresql with pg_trgm Posted on August 20, 2017 I have been researching postgresql search capabilities for quite a while. Besides the very powerful Full Text Search capabilities the engine offers today, there are a few less known index types that support string searches in the form : where foo like ‘%bar%’ For these cases, a regular b-tree index on ‘foo’ is guaranteed to never be used. The following example illustrates a case in which a relatively simple query is transformed to.. Read More 1 2 » Recent Posts IO performance on an ASUS Pro WS WRX80/AMD ThreadRipper server Resync postgresql standby with wal-g catchup Postgresql Performance on Ubuntu linux 18.04 and Amazon AWS EC2 iXL instance Postgresql Performance on Ubuntu linux 18.04 and Nutanix GDPR article mapping to RDBMs feature availability Recent Comments Archives July 2021 February 2021 January 2020 May 2018 August 2017 September 2016 August 2016 June 2015 Categories Data Science FAQ GDPR General Kafka Linux Machine Learning MariaDB Mathematics Mysql Performance Postgresql Meta Aleph Technologies SPRL © 2024 - Aleph...