Ajit Gadge

Field CTO-APJ

Ajit is an accomplished IT executive, strategist, advisor, and evangelist with 23+ years of experience in executive, technical, and architectural leadership positions at many IT companies. He advises many BFSI, Telcos, Retail, and Enterprise customers on their Opensource Databases and Analytics strategy and technology deployments. He is passionate about Data technologies and evangelists in cloud technologies. His expertise and practice areas are digital transformation, Cloud, Observability, and Datastore. He has spoken at major conferences and hosted webcasts, podcasts, and video chats. He has his engineering graduation from Mumbai University and a PG in Fintech Technologies from NUS (National University of Singapore). He has also done several technology certifications, including TOGAF.

Read Blogs

Postgres Tutorials

PostgreSQL로 검색 기능 향상: 표준 검색에서 시맨틱 검색까지

Ajit Gadge · 2024년 4월 25일 디지털 세계에서 ‘검색’은 매우 흥미로운 주제입니다. 데이터를 텍스트로 바라보면 숫자가 측정과 계산을 위해 존재하는 데이터인 것처럼, 텍스트는 검색을 위해 존재하는 데이터라고 할 수 있습니다. 디지털 시대에는 방대한 텍스트 데이터를 효율적이고 효과적으로 분류하는 능력이 매우 중요합니다. PostgreSQL은 간단한 패턴 매칭부터 언어 기반의 풀 텍스트 검색, 더욱 복잡한 시맨틱 검색까지 다양한 검색 기능을 제공합니다. 이 글에서는 ‘PostgreSQL & vector’와 관련된 기사를 찾는 예제를 통해 표준 검색, 풀 텍스트 검색, 시맨틱 검색의 차이와 사용 사례, 작동 방식을 살펴봅니다. 예제 데이터는 여러 기사에서 가져온 텍스트를 PostgreSQL의 열...
Technical Blog

Transforming Real-Time Analytics and AI Workloads with PostgreSQL

PostgreSQL with pgvector transforms real-time analytics and AI workloads, breaking data silos with scalable data integration architecture and advanced database AI.
Postgres Tutorials

Next-Gen PostgreSQL: From ACID to AI

Many organisations have used Traditional OLTP databases for many years for different use cases because Excel handles your structure data with ACID compliance. However, it often needs to catch up regarding operations involving high-dimensional vector data, which is crucial for modern NLP tasks. The challenge lies in efficiently storing, indexing, and retrieving these vectors representing text data for real-time applications.
Postgres Tutorials

Enhancing Search Capabilities with PostgreSQL: From Standard to Semantic.

In the digital age, the ability to sift through vast amounts of text data efficiently and effectively is crucial. PostgreSQL, a robust open-source relational database, offers various search functionalities that cater to multiple needs, from simple pattern matching to linguistic search and more complex semantic search understanding. This article explores these search methods—standard search, full-text search, and semantic search—using the example of searching for articles related to "PostgreSQL & vector" to illustrate their differences, use cases, and internal workings.