Tag: tag

Architecture comparison showing complex specialized vector database setup versus simple PostgreSQL pgvector unified solution for AI workloads

Why PostgreSQL Beat Specialized Vector Databases: A DBA’s Perspective

Posted on by sanjeeva

Last Updated: December 2025 | By Sanjeeva Kumar | 20+ Years in Database Systems The Plot Twist Nobody Saw Coming Two weeks ago, PostgreSQL’s pgvector extension released version 0.8.0. Within days, the entire vector database market collectively held its breath. Why? Because that “old guard” relational database just made billion-dollar vector database startups look like Read more about Why PostgreSQL Beat Specialized Vector Databases: A DBA’s Perspective[…]

PostgreSQL Meta-Command using psql: Command Information -IV

Posted on by sanjeeva

This is in continuation of My last blog about Meta Commands in PostgreSQL. In last blog I have explained what a Meta command and how to list databases. In next few blogs we will explore few of Meta commands. Lets start exploring schemas. Visit this series of last blog for other command. The command we Read more about PostgreSQL Meta-Command using psql: Command Information -IV[…]

PostgreSQL Meta-Command using psql: Command Information -III

Posted on by sanjeeva

This is in continuation of My last blog about Meta Commands in PostgreSQL. In last blog I have explained what a Meta command and how to list databases. In next few blogs we will explore few of Meta commands. Lets start exploring schemas. Visit this series of last blog for other command. The command we Read more about PostgreSQL Meta-Command using psql: Command Information -III[…]

PostgreSQL Meta-Command using psql: Command Information -II

Posted on by sanjeeva

This is in continuation of My last blog about Meta Commands in PostgreSQL. In last blog I have explained what a Meta command is all about. In next few blogs we will explore few of Meta commands. Lets start exploring databases. The command we will explore here is:1. \l2. \c Once you connected to a Read more about PostgreSQL Meta-Command using psql: Command Information -II[…]

PostgreSQL Meta-Command using psql: Command Information -I

Posted on by sanjeeva

This is in continuation of My last blog about Meta Commands in PostgreSQL. In last blog we have explained what a Meta command is all about. In next few blogs we will explore few of Meta commands. Let’s start with psql command itself. Once we logged in using psql, the environment should be look like Read more about PostgreSQL Meta-Command using psql: Command Information -I[…]

PostgreSQL Meta-Command using psql: Generic Information

Posted on by sanjeeva

In our last blog we have discussed the history of origination of PostgreSQL database. This database, like all other RDBMS, has more than one interface to connect to the database. PostgreSQL has psql program as command line interface (CLI) and PgAdmin as graphical user interface (GUI) psql as complete set of commands through which we Read more about PostgreSQL Meta-Command using psql: Generic Information[…]