Tag: PostgreSQL
-
SQL Joins: Combining Tables with INNER and LEFT JOIN (Data Analyst Series, Part 7)
Learn SQL joins the practical way. INNER JOIN keeps matches, LEFT JOIN keeps every row, and the ON versus WHERE trap that quietly drops the rows you need.
-
SQL SELECT, WHERE and ORDER BY: Your First Queries (Data Analyst Series, Part 6)
Write your first real SQL queries. SELECT to choose columns, WHERE to filter rows, ORDER BY to sort and LIMIT to cap, all against a five-row sample table.
-
Database Self-Service in VCF Automation with Data Services Manager (VCF Automation 9 Series, Part 31)
How to turn a Postgres ticket into a self-service deployment in VCF Automation 9 using Data Services Manager: the architecture, the infrastructure-policy choice that decides VKS placement, the provider wiring, the tenant flow, and the licensing and engine-support traps.
-
Vector Databases in VMware Private AI: Running pgvector on Data Services Manager (Private AI Series, Part 13)
A reference-architecture look at the retrieval tier of VMware Private AI: where DSM-managed PostgreSQL with pgvector sits, how to place and size it, and whether to index with HNSW or IVFFlat.
Architect’s Toolkit
PJ’s Tools
- Infra 360 Hub – All Series
- VCF 9 Interactive Walkthroughs
- VCF Design Cheatsheet
- VCF Upgrade Planner
- VCF 9 Series Hub
- VCF Deployment Hub
- AI Stack Hub
- AI Infra Sizing & Cost Calculator
- LLM & RAG Cost Calculator
- DrJhaGPT – Ask Pranay
VMware Cloud Foundation
- VCF Documentation
- VCF 9 Planning & Preparation Workbook
- VCF Bill of Materials (BoM)
- VMware Compatibility Guide
- VMware Interoperability Matrix
- VMware Configuration Maximums
- VMware Ports & Protocols
- VMware Hands-on Labs
- RVTools Download
Nutanix
AI & Cloud-Native Platform
- NVIDIA Build (Model Catalog)
- NVIDIA AI Enterprise Reference Architecture
- NVIDIA NIM Performance Benchmarking
- NVIDIA NGC Catalog
- NeMo Microservices Helm Chart
- Helm Charts Repository
- Hugging Face Models
Architecture & Design
About the Author
Dr Pranay Jha
Dr. Pranay Jha is a Cloud and AI Consultant with 18+ years of experience in hybrid cloud, virtualization, and enterprise infrastructure transformation. He specializes in VMware technologies, multi-cloud strategy, and Generative AI solutions. He holds a PhD in Computer Applications with research focused on Cloud and AI, has published multiple research papers, and has been a VMware vExpert since 2016 and a VMUG Community Leader.
You May Have Missed
DrJha