Amul Sul

Senior Staff Software Engineer (SDE)

As a Senior Staff SDE, Amul works predominantly on database server development at EDB. He is an active contributor in PostgreSQL feature development as well as in EDB Postgres Advanced Server propriety feature development. Amul has a cumulative experience of 12 years in database development.

Prior to EDB, he was a Senior Software Engineer at NTT Data. Amul holds a Master degree in Computer Application from Mumbai University.  

Read Blogs

Technical Blog

미세한 변화: PostgreSQL의 NOT VALID와 NOT ENFORCED 제약 조건 이해하기

작성자: Amul Sul 작성일: 2026년 3월 27일 PostgreSQL은 뛰어난 데이터 무결성(Data Integrity)을 제공하는 데이터베이스로 잘 알려져 있습니다. 그러나 데이터 세트가 테라바이트 단위로 커지면 제약 조건을 검사하고 검증하는 비용이 시스템 운영의 부담으로 이어질 수 있습니다. PostgreSQL은 이러한 상황에 대응할 수 있도록 제약 조건에 여러 상태를 제공합니다. 기존의 NOT VALID 옵션은 대용량 테이블에 제약 조건을 추가할 때 널리 활용돼 왔습니다. PostgreSQL 18에는 SQL:2023 표준의 개념인 NOT ENFORCED가 공식 도입됐습니다. 이름은 비슷하지만 두 옵션은 기존 데이터와 새 데이터의 검사 여부, 내부 트리거 생성 여부, 활용 목적에서 뚜렷한 차이가...
Technical Blog

The Subtle Shift: Understanding NOT VALID vs. NOT ENFORCED Constraints in PostgreSQL

PostgreSQL is famous for its data integrity, but as datasets grow into terabytes, the cost of maintaining that integrity can become a bottleneck. To solve this, PostgreSQL offers different "states" for constraints. While many are familiar with NOT VALID, a new concept from the SQL:2023 standard has entered the conversation: NOT ENFORCED, which has been officially added to PostgreSQL 18 . While...
Technical Blog

What Happens to My Existing DBMS_JOB and DBMS_SCHEDULER’s Jobs After Upgrading to EPAS 16?

EDB Postgres Advanced Server (EPAS) 16 has removed the dependency on PgAgent for job scheduling and has added a new extension called edb_job_scheduler, which supports job scheduling through dbms_job and dbms_scheduler. This extension operates via background workers, is easy to configure, and stays under the control of the database server. For more details on the new job scheduler extension, please...
Postgres Tutorials

Interval Partitioning in EDB Postgres Advanced Server: Auto-create a new partition when inserted data exceeds the range

EDB Postgres Advanced Server v12 (EPAS) introduces the Interval Partitioning feature. Interval partitioning allows a database to automatically create a new partition when newly inserted data exceeds the range of an existing partition.

Native Data Redaction Capability in EDB Postgres Advanced Server 11

Marc Linster has posted a blog Creating a Data Redaction Capability to Meet GDPR Requirements Using EDB Postgres to demonstrate data redaction on EDB Postgres Advanced Server 10, which has taken the approach to leverage the PostgreSQL search_path feature to direct privileged users to the raw unredacted data when they run a query, and to direct non-privileged users to a view that implements...