Default Author

Beena Emerson

Postgres Internals Developer, EDB

Beena Emerson is a Postgres Internals Developer with more than a decade of experience working with various aspects of Postgres and EDB’s Advance Server. She has contributed to projects like multiple synchronous  replication, runtime partition pruning and zheap. She has developed many oracle-compatibility feature for Advance Server as well.

Before joining EDB she worked with NTT data and that is where she learns about Postgres and started contributing to the project. She has also presented multiple times in Pgconf India.

Beena is currently settled in Chennai with her family. She is also a Purpose Coach and spends her weekend hosting webinars and sessions to empower people to work on their strengths and create the life of their dreams.

Read Blogs

Postgres Tutorials

Partition Pruning During ExecutionPartition Pruning During Execution

Partitioning in Postgresql eases handling large volumes of data. This feature has greatly improved with the introduction of declarative partitioning in PostgreSQL 10, paving way for better query optimization and execution techniques on partitioned tables.
Postgres Tutorials

How to benchmark partition table performance

With the addition of declarative partitioning in PostgreSQL 10, it only made sense to extend the existing pgbench benchmarking module to create partitioned tables. A recent commit of patch by Fabien Coelho in PostgreSQL 13 has made this possible.
Postgres Tutorials

How Bulkload performance is affected by table partitioning in PostgreSQL

This article covers how benchmark tests can be used to demonstrate the effect of table partitioning on performance.
Postgres Tutorials

What is Multi-column Partitioning in PostgreSQL and How Pruning Occurs

This article covers how to create a multi-column partitioned table and how pruning occurs in such cases.
Postgres Tutorials

How to Auto Generate Hash Partitions In EDB Postgres Advanced Server

This article covers the new feature to auto create hash partitions in EDB Postgres Advanced Server 13.
Postgres Tutorials

How to Create Subpartition Template in EDB Postgres Advanced Server 14

Looking for an introduction to the new auto-create subpartitions feature in EDB Postgres Advanced Server 14? Software Engineer Beena Emerson is here to guide you on your way to understanding this time-saving new feature.