logo

Blog - Expert Tech Insights and Ideas - Explore

/static/c29b661b98df800199c5ed3570321c4e/27625/title-image.png
Engineering

Creating Indexes on 750 Million Rows in PostgreSQL

Creating indexes on massive tables in PostgreSQL can be a performance game-changer—but only if done right. In this post, we explore how to safely and efficiently create a unique index on a 750 million-row table in an AWS RDS environment, while monitoring its progress using built-in PostgreSQL tools.

Jerrish Varghese

May 12, 2025

Discover Other Blog

Delve into our insightful blog posts and stay ahead of the curve with our expert analysis on the latest technology trends.
blogImage
Creating Indexes on 750 Million Rows in PostgreSQL

Jerrish Varghese

May 12, 2025

blogImage
Zustand vs. Redux: Why Simplicity Wins in Modern React State Management

Sharath Vijayan Nair

April 28, 2025

blogImage
Deploying PostgreSQL on Kubernetes with NodePort: A Complete Guide

Ashish Sharma

April 18, 2025

blogImage
EDSTEM Unite 2025 - All Hands Meetup

Sachin Biju

April 11, 2025

blogImage
Deploying OpenSearch and Kafka (Kafdrop) on Kubernetes

Ashish Sharma

March 25, 2025

blogImage
ECLD Offsite: Empowering Fresh Talent Through Immersive Learning

Sharath Vijayan Nair

March 11, 2025

blogImage
Optimizing Web Performance: Faster User Experiences – Part 1

Faiz Ahmed Khan

February 20, 2025

blogImage
Document Parser Data Pipeline using Apache Kafka

Sangeeta Saha, Ashwanth K

February 10, 2025

blogImage
Using AWS Bedrock for ClaudeMind Plugin in IntelliJ IDEs

Jerrish Varghese

January 30, 2025

blogImage
Cloud Native Email Automation with AWS SES, Python, Flask, and Jinja2

Sharath Vijayan Nair

January 23, 2025

blogImage
Orchestrating Async Workflows with AWS Step Functions and Flask

Sharath Vijayan Nair

January 16, 2025

blogImage
Deploying and Running an App on S3 and CloudFront Using Terraform

Ashish Sharma

January 02, 2025

blogImage
Christmas Celebration Dinner at Grand Hyatt Kochi Bolgatty

Sachin Biju

December 21, 2024

blogImage
Using Testcontainers - Revolutionizing Our Test Infrastructure

Jerrish Varghese

November 18, 2024

blogImage
Secure Secrets Management - Our Journey with SOPS

Jerrish Varghese

November 15, 2024

blogImage
Optimizing LLM Responses - Our Journey with RAG

Jerrish Varghese

November 13, 2024

blogImage
K9s - Transforming Kubernetes Cluster Management with a Modern TUI

Jerrish Varghese

November 08, 2024

blogImage
Ditching Postman - Why We Embraced Bruno for API Testing

Jerrish Varghese

November 04, 2024

blogImage
Migrating from AWS SDK v2 to v3 in Node.js AWS Lambda Functions

Ashish Sharma

August 14, 2024

blogImage
Understanding Vite Bundle Visualizer: A Frontend Engineer’s Guide

Jerrish Varghese

August 12, 2024

blogImage
Unleash the Power of Feature Management in Your Applications

Jerrish Varghese

August 09, 2024

blogImage
json vs jsonb in PostgreSQL: Key Differences for Developers

Jerrish Varghese

August 07, 2024

blogImage
Implementing RBAC in Spring Boot for a Municipal Management System

Jerrish Varghese

August 05, 2024

blogImage
Secure Database Access: Leveraging IAM Authentication for AWS RDS

Jerrish Varghese

August 01, 2024

blogImage
Automating Data Retention in AWS OpenSearch with ISM

Ashish Sharma

June 20, 2024

blogImage
Integrating OneLogin with an Angular Application

Ashish Sharma

June 17, 2024

blogImage
Setting Up Kafdrop on Ubuntu EC2 Instance with SSL Configuration

Ashish Sharma

June 14, 2024

blogImage
Exclude Lombok-Generated Methods from Jacoco Coverage Reports

Jerrish Varghese

June 03, 2024

blogImage
Check and Create an OIDC Provider for Your AWS EKS Cluster

Jerrish Varghese

May 16, 2024

blogImage
Separating Read and Write DataSources in Spring Boot

Jerrish Varghese

May 03, 2024

blogImage
Implementing Rate Limiting for Specific URLs Using AWS WAFv2

Aravind Sankar

May 01, 2024

blogImage
Publishing Third-Party JARs to GitHub Packages: A Maven Guide

Jerrish Varghese

April 26, 2024

blogImage
Setting Up a Subdomain Hosted Zone in a Different AWS Account

Aravind Sankar

April 24, 2024

blogImage
Creating Forms using React Hook Form and Yup

Sangeeta Saha

April 22, 2024

blogImage
Achieving Seamless SAML Authentication with Azure AD in OpenSearch

Ashish Sharma

April 19, 2024

blogImage
Enabling EKS Pod Logs on OpenSearch

Ashish Sharma

April 18, 2024

blogImage
Mock Service Worker for Development and Testing

Sangeeta Saha

April 16, 2024

blogImage
Authentication Using Microsoft Authentication Library (MSAL)

Sangeeta Saha

April 15, 2024

blogImage
Micro Frontend using Single SPA and Qiankun

Sangeeta Saha

April 09, 2024

blogImage
AWS Cost Optimization: Automating RDS and EC2 Instance Management

Ashish Sharma

April 05, 2024

blogImage
Streamlining Web Testing: Integrating Selenium with Sauce Labs

AryaKrishna

April 02, 2024

blogImage
Securely Upload and Fetch Files in Azure Blob via SAS Token

Sangeeta Saha

March 13, 2024

blogImage
Empowering Women, Empowering Futures - Inspiring Women's Journeys

Sachin Biju, Anisha Mariam Thomas, Sangeeta Saha, Nancy Alfred

March 08, 2024

blogImage
Optimizing AWS EKS Costs with Terraform: A Comprehensive Guide

Ashish Sharma

March 01, 2024

blogImage
Java vs Python: Which Programming Language Reigns Supreme?

Christina Antony

February 21, 2024

blogImage
Index as a Unique Constraint: Pros and Cons in Databases

Eby Augustine

February 12, 2024

blogImage
Navigating Complex Aggregations in Amazon OpenSearch with Java

Jerrish Varghese

February 05, 2024

blogImage
Automating Kafka Topic Configuration Management with Python

Jerrish Varghese

January 31, 2024

blogImage
How to Identify and Kill Long-Running Queries in PostgreSQL

Jerrish Varghese

January 22, 2024

blogImage
Implementing Dynamic Feature Toggles in Spring Boot

Jerrish Varghese

January 16, 2024

blogImage
Streamlining AWS Lambda with DuckDB for Dynamic Data Handling

Jerrish Varghese

January 08, 2024

blogImage
Kafka Retry Mechanism in Spring Kafka

Eby Augustine

January 04, 2024

blogImage
Optimizing Performance with Redis Response Caching in Spring Boot

Jerrish Varghese

December 26, 2023

blogImage
Leveraging GitHub Actions for Scheduled Workflows

Jerrish Varghese

December 20, 2023

blogImage
Secure JWT Propagation in Microservices with Spring Cloud

Jerrish Varghese

December 13, 2023

blogImage
Harnessing the Power of PostgreSQL's COPY Command for Rapid Data Migration

Jerrish Varghese

November 07, 2023

blogImage
Knowledge Sharing Culture – Cultivating a Learning Environment for Freshers

Aravind Sankar

September 22, 2023

blogImage
Onam Celebration Team Meetup: A Day of Joy, Unity, and Celebration

Biju PS

August 31, 2023

blogImage
Supercharging Agile: Harnessing the Benefits of Retrospectives

Aravind Sankar

July 14, 2023

blogImage
Migrating Jenkins Pipelines to GitHub Actions: A Comprehensive Guide

Azhar MA

May 30, 2023

blogImage
Using Kubernetes Sidecar Pattern for Efficient Data Sync

Jerrish Varghese

March 09, 2023

blogImage
Introduction to the Object Mother Pattern in Software Testing

Jerrish Varghese

January 20, 2023

blogImage
Edstem's 2021 Retreat: Team Bonding Success

Thomas Oommen

December 11, 2021

/static/subscribe_blog_cover-8480bc024ed246aa61f070a0d31b4a8f.png
Subscribe to
our blog

Unlock a world of software expertise! Subscribe to our blog for the latest industry trends, tips, and innovations.

logofooter
title_logo

USA

Edstem Technologies LLC
254 Chapman Rd, Ste 208 #14734
Newark, Delaware 19702 US

INDIA

Edstem Technologies Pvt Ltd
Office No-2B-1, Second Floor
Jyothirmaya, Infopark Phase II
Ernakulam, Kerala 682303
iso logo

About

About us

Leadership

News room

ISO certification

Services

IT Consulting

Cloud Native Solutions

Software Engineering

DevSecOps

Custom Software

Mobile App Development

Data Engineering

Resource Augmentation

Resource Augmentation - Frontend Engineer

Work With Us
Blog
facebookinstagraminstagram
India : +91 80-456-80957USA : 1 (302) 455-2551info@edstem.com

© 2024 — Edstem All Rights Reserved

Privacy PolicyTerms of Use