Dinesh Kumar

Dinesh Kumar is an expert PostgreSQL and Oracle developer. Dinesh is currently working as a Tech Lead at MigOps. Before joining MigOps, Dinesh worked as a Consultant at Amazon Web Services, OpenSCG as a Database Engineer and EnterpriseDB as software developer. Dinesh has contributed to pgAdmin development and custom extensions to incorporate Oracle compatibility in PostgreSQL and several business use cases. Dinesh is also a certified AWS DevOps professional, he love to build cloudfoundry bosh, Kubernetes, PostgreSQL solutions and likes to code in C/C++ and Golang. He is also a co-author of PostgreSQL High Performance CookBook and he holds a master degree in computer science.

SELECT FOR UPDATE and its behavior with foreign keys in PostgreSQL

The general approach followed by developers is to pre-acquire the lock(FOR UPDATE)on the data sets that are being updated/deleted concurrently. This approach may be considered to solve the dead lock problem or to control the concurrent access to one or more rows, but could sometimes lead to an unnecessary locking behavior. In this article we shall discuss about …

SELECT FOR UPDATE and its behavior with foreign keys in PostgreSQL Read More »

CentOS vs Rocky Linux Benchmark with PostgreSQL

In December 2020, you might have seen an article from CentOS about shifting their focus towards CentOS stream, which is the upstream version of the RHEL. CentOS also mentioned that the version 8 would be EOL (end of life) by the end of the 2021. This means that it will no longer receive any updated fixes from it’s …

CentOS vs Rocky Linux Benchmark with PostgreSQL Read More »

Announcing Credcheck extension to enforce username and password checks in PostgreSQL

PostgreSQL includes robust security standards around all aspects such as authentication, authorization, accounting and auditing. User management and role based segregation that satisfy enterprise standards can be implemented at ease. Similarly, organizations may be willing to enforce certain compliance around the password standards such as the minimum upper case characters or minimum number of numbers and special characters …

Announcing Credcheck extension to enforce username and password checks in PostgreSQL Read More »

Scroll to Top