PostgreSQL as a Vector Database: Part 1, Getting Started With pgvector

Denis Magda • November 28, 2023

Denis Magda

View Channel

About

The place where application developers master databases

Latest Posts

PostgreSQL Internals in Action: Shared Memory and Buffers

Denis Magda

Generating Embeddings with Spring AI: Step-by-Step Guide with Pitfalls

Denis Magda

PostgreSQL Internals in Action: MVCC

Denis Magda

Upgrade Your iPhone Experience

AI-recommended products based on this video

BASESAILOR iPhone 16 16e Car Charger Adapter 3Pack,USB to USBC Connector Type C Female to A Male Cable Converter for iPhone 15 14 Pro Max Plus,Apple Watch 10,Airpods 4,iPad mini 7,Samsung Galaxy S25

(7,876)

$11.99

FREE delivery Sat, Jun 14 on your first order

500+ bought in past month

URVNS 240W USB C Car Charger, Super Fast Charging 4-Ports PD3.1 140W/PD3.0 100W PPS 45W QC65W Type-C Car Adapter for MacBook Pro Laptop iPhone 15 14 Max iPad Samsung Galaxy S24/23/22 Pixel etc

(114)

$57.36$49.99

Prime$5.48 delivery Mon, Jun 16

UGREEN 130W Car Charger USB C Fast Charger PD3.0 QC4.0 PPS Fast Charging Car Adapter with 100W USB C Cable Compatible with Dell XPS, MacBook, iPhone 16 15 14 Pro Max, Galaxy S25 S24 Ultra, iPad Pro

(4,725)

$31.99

500+ bought in past month

VANMASS [85+LBS Strongest Suction & Clip] 2025 Upgrade Car Phone Holder [Patent & Safety Certs] Cell Phone Mount Truck Stand for Dashboard Windshield Vent for iPhone 16 Pro Max 15 14 13 12 Samsung

(54,882)

$32.25

FREE delivery Mon, Aug 25 on your first order

1K+ bought in past month

Lightning to 3.5mm Audio Jack Adapter Apple MFi Certified iPhone Headphone Jack Adapter Lightning to Aux Adaptor Dongle for iPhone 14 13 12 11 XS XR X 8 7 2 Pack

(40)

$10.79

Prime

500+ bought in past month

Spigen Case for iPhone 15, iPhone 14, and iPhone 13, Ultra Hybrid MagFit Designed for Apple iPhone 15/14/13 - Crystal Clear

(1,204)

$20.99

FREE delivery Sat, Sep 20 on your first order

100+ bought in past month

ESR for iPhone 14 Pro Case MagSafe, Shockproof Military-Grade Protection, Scratch-Resistant Back, Classic Hybrid Magnetic Case Compatible with iPhone 14 Pro 6.1 inch, Clear Purple

(12,774)

$16.99

FREE delivery Sat, Sep 20 on your first order

400+ bought in past month

JETech Case for iPhone 14 6.1-Inch, Non-Yellowing Shockproof Phone Bumper Cover, Anti-Scratch Clear Back (Clear)

(15,389)

$11.99

FREE delivery Sat, Sep 20 on your first order

1K+ bought in past month

Apple AirTag 4 Pack

(333,593)

$108.98

FREE delivery Sat, Sep 20

5K+ bought in past month

Best Seller

Apple AirTag 1 Pack

(193,955)

$31.98$29.10

FREE delivery Sat, Jun 14 on your first order

5K+ bought in past month

Citymore 4 Pack IPX8 Waterproof for AirTag Keychain，with Soft Silicone AirTags Holder Case Key Ring, Compatible with Apple AirTag for Luggage,Keys, Dog Collar etc

(2,559)

$11.96

FREE delivery Sat, Sep 20 on your first order

3K+ bought in past month

HATALKIN Case Compatible with Apple AirTags Case Keychain Air tag Holder Air Tag Key Ring Cases Air Tags Protective Cover Airtag Key Chain Loop Holders Silicone for Luggage Dog Cat Pet Collar 4 Pack

(19,279)

$9.78

FREE delivery Mon, Aug 25 on your first order

1K+ bought in past month

Yarxiawin Phone Case for Samsung S25 Case with Ring Stand Magnetic Compatible with Magsafe Wireless Charger, Pink Bumper Cover Samsung Galaxy S25 Case Clear Shockproof (Blue)

(0)

$20.23

FREE delivery Sat, Jun 14 on your first order

AsperX for Magsafe Power Bank, 10000mAh Wireless Magnetic Power Bank, 22.5W Wire Fast Charging Portable Charger with USB C Cable, LCD Display for Magsafe Battery Pack for iPhone 16/15/14/13/12

(895)

$37.98

FREE delivery Sat, Sep 20

400+ bought in past month

Apple Watch Series 10 [GPS 46mm] Smartwatch with Rose Gold Aluminium Case with Light Blush Sport Band. Fitness Tracker, ECG App, Always-On Retina Display, Water-Resistant

(1,728)

$413.99

Prime

400+ bought in past month

Best Seller

LK 6 Pack Screen Protector for Apple Watch Series 11 46mm, Self-Healing TPU Material for iWatch 46mm Screen Protector, Scrathes-Resistant, Bubble-Free, HD Clarity, Anti-Glare, Transparent Global Recycled Standard

(1,111)

$16.99

FREE delivery Sun, Oct 5 on your first order

4-in-1 Wireless Magnetic Power Bank 10800mAh Portable Charger with iWatch Charger, QC4.0+20W PD Fast Charging USB C Battery Pack for Magsafe, iPhone 16/15/14/13/12 Series, Apple Watch etc. (White)

(581)

$42.95

PrimeFREE delivery Sat, Jun 14

Apple Watch Series 10 [GPS 46mm] Smartwatch with Jet Black Aluminium Case with Black Sport Band. Fitness Tracker, ECG App, Always-On Retina Display, Water-Resistant

(17)

$488.99$444.98

FREE delivery Tue, Sep 30

1K+ bought in past month

Apple AirPods Pro 2 Wireless Earbuds, Bluetooth Headphones, Active Noise Cancellation, Transparency, Personalized Spatial Audio, High-Fidelity Sound, H2 Chip, USB-C Charging

(26,678)

$259.99$194.99

FREE delivery Wed, Aug 20

5K+ bought in past month

Best Seller

Cleaner Kit for Airpods Pro 1 2 3 Multi-Function Cleaning Pen with Soft Brush Flocking Sponge for Bluetooth Earphones Case Cleaning Tools White

(9,766)

$9.89

FREE delivery Sat, Jun 14 on your first order

500+ bought in past month

iPhone 16 15 Charger [Apple MFi Certified] 2 Pack USB C Wall Charger Block 6FT USB C to Type C Cable Compatible with iPhone 16 15 Pro Max,16e, AirPods Pr, iPad Pro12.9/11, Samsung/Android Phones

(321)

$17.99

FREE delivery Sat, Jun 14 on your first order

50+ bought in past month

Anker 332 USB-C Hub (5-in-1) with 4K HDMI Display, 5Gbps - and 2 5Gbps USB-A Data Ports and for MacBook Pro, MacBook Air, Dell XPS, Lenovo Thinkpad, HP Laptops and More

(11,639)

$23.99

FREE delivery Sat, Jun 14 on your first order

1K+ bought in past month

Spigen Case for Galaxy S25 Case, Tough Armor (Ai) MagFit [Wireless Charging] Compatible with MagSafe - Black

(2,126)

$28.99

FREE delivery Sat, Jun 14 on your first order

500+ bought in past month

Spigen Case for iPhone 16 Case, Tough Armor Designed for Apple iPhone 16 - Black

(126)

$22.99

FREE delivery Sat, Jun 14 on your first order

50+ bought in past month

Spigen Case for iPhone 16 Pro Case, Tough Armor [MagFit] Compatible with MagSafe - Black

(341)

$32.99

FREE delivery Sat, Jun 14 on your first order

Spigen Case for iPhone 16 Plus Case, Tough Armor (AI) [MagFit] Compatible with MagSafe - Black

(818)

$29.99

FREE delivery Sat, Jun 14 on your first order

JoyGeek 3-in-1 Magnetic Wireless Charging Station for iPhone 16/15/14/13/12 Series & Apple Watch Ultra 2/SE; 360° Adjustable Phone Stand with 18W Adapter, Compatible with AirPods Pro/3/2 Recycled Claim Standard Blended

(959)

$19.99

FREE delivery Sat, Jun 14 on your first order

MRGLAS 2025 Upgraded Magsafe Car Mount Vacuum Suction Magnetic Phone Holder Car, 360° Foldable Adjustable Suction Cup Phone Stand [89+LBS Suction & 2800gf Magnetic] for Car Accessories iPhone17/16

(1,124)

$27.19

1K+ bought in past month

OHLPRO Tablet Car Mount Universal Tablet Holder for Car Windshield Dash Dashboard, 360 Degree Rotation,TPU Suction Gel Stick, for iPad Mini 4/3/2/1Samsung Galaxy Size 7"- 10.5" Tablet Mount

(1,515)

$18.99

FREE delivery Tue, Jun 17 on your first order

Magnetic Car Mount Air Vent Cell Phone Holder, Universal Vehicle Dash Dashboard Ac Airvent Cellphone Magic Stand with Clip Hook, for iPhone 16 15 Samsung Lenovo Google etc

(128)

$21.99

FREE delivery Tue, Jun 17 on your first order

AINOPE Phone Holder for Car Vent 2025 Gravity Air Vent Car Phone Holder Mount for iPhone 16 Pro Max with Vent Clip Hand Free Cell Phone Car Mount for iPhone 16 Plus Samsung S25 Ultra Car Accesorries

(29,179)

$19.99$18.17

FREE delivery Tue, Jun 17 on your first order

2K+ bought in past month

PostgreSQL as a Vector Database: Part 1, Getting Started With pgvector

Denis Magda

About

Latest Posts

PostgreSQL Internals in Action: Shared Memory and Buffers

Generating Embeddings with Spring AI: Step-by-Step Guide with Pitfalls

PostgreSQL Internals in Action: MVCC

You May Also Like

PostgreSQL as a Vector Database: Part 2, Using HNSW Index

How does a Vector Database work?

PM Check: Tips and Tricks | PREVIEW

I Quit an AI Startup After 6 Months - Here's What I learned

18 Months of Pgvector Learnings in 47 Minutes (Tutorial)

MVCC Unmasked

Vector Database Tutorial For Beginners | PostgreSQL| Open AI | Node.js

PostgreSQL Internals in Action: MVCC

What is a Vector Database? Powering Semantic Search & AI Applications

Big Updates to Redis: Context Engine, Tools, and Memory

Supabase Postgres Vector DB Crash Course

How To Learn Any Skill So Fast It Feels Illegal

Ex-OpenAI Scientist WARNS: "You Have No Idea What's Coming"

Spring AI With PostgreSQL pgvector: Building Generative AI Apps in Java

Solving one of PostgreSQL's biggest weaknesses.

PGVector: Turn PostgreSQL Into A Vector Database

PostgreSQL as VectorDB - Beginner Tutorial

Don't learn AI Agents without Learning these Fundamentals

Postgres pgvector Extension - Vector Database with PostgreSQL / Langchain Integration

PostgreSQL as a Vector Database: Part 1, Getting Started With pgvector

Denis Magda

About

Latest Posts

PostgreSQL Internals in Action: Shared Memory and Buffers

Generating Embeddings with Spring AI: Step-by-Step Guide with Pitfalls

PostgreSQL Internals in Action: MVCC

You May Also Like

PostgreSQL as a Vector Database: Part 2, Using HNSW Index

How does a Vector Database work?

PM Check: Tips and Tricks | PREVIEW

I Quit an AI Startup After 6 Months - Here's What I learned

18 Months of Pgvector Learnings in 47 Minutes (Tutorial)

MVCC Unmasked

Vector Database Tutorial For Beginners | PostgreSQL| Open AI | Node.js

PostgreSQL Internals in Action: MVCC

What is a Vector Database? Powering Semantic Search & AI Applications

Big Updates to Redis: Context Engine, Tools, and Memory

Supabase Postgres Vector DB Crash Course

How To Learn Any Skill So Fast It Feels Illegal

Ex-OpenAI Scientist WARNS: "You Have No Idea What's Coming"

Spring AI With PostgreSQL pgvector: Building Generative AI Apps in Java

Solving one of PostgreSQL's biggest weaknesses.

PGVector: Turn PostgreSQL Into A Vector Database

PostgreSQL as VectorDB - Beginner Tutorial

Don't learn AI Agents without Learning these Fundamentals

Postgres pgvector Extension - Vector Database with PostgreSQL / Langchain Integration

Upgrade Your iPhone Experience

BASESAILOR iPhone 16 16e Car Charger Adapter 3Pack,USB to USBC Connector Type C Female to A Male Cable Converter for iPhone 15 14 Pro Max Plus,Apple Watch 10,Airpods 4,iPad mini 7,Samsung Galaxy S25

URVNS 240W USB C Car Charger, Super Fast Charging 4-Ports PD3.1 140W/PD3.0 100W PPS 45W QC65W Type-C Car Adapter for MacBook Pro Laptop iPhone 15 14 Max iPad Samsung Galaxy S24/23/22 Pixel etc

UGREEN 130W Car Charger USB C Fast Charger PD3.0 QC4.0 PPS Fast Charging Car Adapter with 100W USB C Cable Compatible with Dell XPS, MacBook, iPhone 16 15 14 Pro Max, Galaxy S25 S24 Ultra, iPad Pro

VANMASS [85+LBS Strongest Suction &amp; Clip] 2025 Upgrade Car Phone Holder [Patent &amp; Safety Certs] Cell Phone Mount Truck Stand for Dashboard Windshield Vent for iPhone 16 Pro Max 15 14 13 12 Samsung

Lightning to 3.5mm Audio Jack Adapter Apple MFi Certified iPhone Headphone Jack Adapter Lightning to Aux Adaptor Dongle for iPhone 14 13 12 11 XS XR X 8 7 2 Pack

Spigen Case for iPhone 15, iPhone 14, and iPhone 13, Ultra Hybrid MagFit Designed for Apple iPhone 15/14/13 - Crystal Clear

ESR for iPhone 14 Pro Case MagSafe, Shockproof Military-Grade Protection, Scratch-Resistant Back, Classic Hybrid Magnetic Case Compatible with iPhone 14 Pro 6.1 inch, Clear Purple

JETech Case for iPhone 14 6.1-Inch, Non-Yellowing Shockproof Phone Bumper Cover, Anti-Scratch Clear Back (Clear)

Apple AirTag 4 Pack

Apple AirTag 1 Pack

Citymore 4 Pack IPX8 Waterproof for AirTag Keychain，with Soft Silicone AirTags Holder Case Key Ring, Compatible with Apple AirTag for Luggage,Keys, Dog Collar etc

HATALKIN Case Compatible with Apple AirTags Case Keychain Air tag Holder Air Tag Key Ring Cases Air Tags Protective Cover Airtag Key Chain Loop Holders Silicone for Luggage Dog Cat Pet Collar 4 Pack

Yarxiawin Phone Case for Samsung S25 Case with Ring Stand Magnetic Compatible with Magsafe Wireless Charger, Pink Bumper Cover Samsung Galaxy S25 Case Clear Shockproof (Blue)

AsperX for Magsafe Power Bank, 10000mAh Wireless Magnetic Power Bank, 22.5W Wire Fast Charging Portable Charger with USB C Cable, LCD Display for Magsafe Battery Pack for iPhone 16/15/14/13/12

Apple Watch Series 10 [GPS 46mm] Smartwatch with Rose Gold Aluminium Case with Light Blush Sport Band. Fitness Tracker, ECG App, Always-On Retina Display, Water-Resistant

LK 6 Pack Screen Protector for Apple Watch Series 11 46mm, Self-Healing TPU Material for iWatch 46mm Screen Protector, Scrathes-Resistant, Bubble-Free, HD Clarity, Anti-Glare, Transparent Global Recycled Standard

4-in-1 Wireless Magnetic Power Bank 10800mAh Portable Charger with iWatch Charger, QC4.0+20W PD Fast Charging USB C Battery Pack for Magsafe, iPhone 16/15/14/13/12 Series, Apple Watch etc. (White)

Apple Watch Series 10 [GPS 46mm] Smartwatch with Jet Black Aluminium Case with Black Sport Band. Fitness Tracker, ECG App, Always-On Retina Display, Water-Resistant

Apple AirPods Pro 2 Wireless Earbuds, Bluetooth Headphones, Active Noise Cancellation, Transparency, Personalized Spatial Audio, High-Fidelity Sound, H2 Chip, USB-C Charging

Cleaner Kit for Airpods Pro 1 2 3 Multi-Function Cleaning Pen with Soft Brush Flocking Sponge for Bluetooth Earphones Case Cleaning Tools White

iPhone 16 15 Charger [Apple MFi Certified] 2 Pack USB C Wall Charger Block 6FT USB C to Type C Cable Compatible with iPhone 16 15 Pro Max,16e, AirPods Pr, iPad Pro12.9/11, Samsung/Android Phones

Anker 332 USB-C Hub (5-in-1) with 4K HDMI Display, 5Gbps - and 2 5Gbps USB-A Data Ports and for MacBook Pro, MacBook Air, Dell XPS, Lenovo Thinkpad, HP Laptops and More

Spigen Case for Galaxy S25 Case, Tough Armor (Ai) MagFit [Wireless Charging] Compatible with MagSafe - Black

Spigen Case for iPhone 16 Case, Tough Armor Designed for Apple iPhone 16 - Black

Spigen Case for iPhone 16 Pro Case, Tough Armor [MagFit] Compatible with MagSafe - Black

Spigen Case for iPhone 16 Plus Case, Tough Armor (AI) [MagFit] Compatible with MagSafe - Black

JoyGeek 3-in-1 Magnetic Wireless Charging Station for iPhone 16/15/14/13/12 Series &amp; Apple Watch Ultra 2/SE; 360° Adjustable Phone Stand with 18W Adapter, Compatible with AirPods Pro/3/2 Recycled Claim Standard Blended

MRGLAS 2025 Upgraded Magsafe Car Mount Vacuum Suction Magnetic Phone Holder Car, 360° Foldable Adjustable Suction Cup Phone Stand [89+LBS Suction &amp; 2800gf Magnetic] for Car Accessories iPhone17/16

OHLPRO Tablet Car Mount Universal Tablet Holder for Car Windshield Dash Dashboard, 360 Degree Rotation,TPU Suction Gel Stick, for iPad Mini 4/3/2/1Samsung Galaxy Size 7&quot;- 10.5&quot; Tablet Mount

Magnetic Car Mount Air Vent Cell Phone Holder, Universal Vehicle Dash Dashboard Ac Airvent Cellphone Magic Stand with Clip Hook, for iPhone 16 15 Samsung Lenovo Google etc

AINOPE Phone Holder for Car Vent 2025 Gravity Air Vent Car Phone Holder Mount for iPhone 16 Pro Max with Vent Clip Hand Free Cell Phone Car Mount for iPhone 16 Plus Samsung S25 Ultra Car Accesorries

Loading...

VANMASS [85+LBS Strongest Suction & Clip] 2025 Upgrade Car Phone Holder [Patent & Safety Certs] Cell Phone Mount Truck Stand for Dashboard Windshield Vent for iPhone 16 Pro Max 15 14 13 12 Samsung

JoyGeek 3-in-1 Magnetic Wireless Charging Station for iPhone 16/15/14/13/12 Series & Apple Watch Ultra 2/SE; 360° Adjustable Phone Stand with 18W Adapter, Compatible with AirPods Pro/3/2 Recycled Claim Standard Blended

MRGLAS 2025 Upgraded Magsafe Car Mount Vacuum Suction Magnetic Phone Holder Car, 360° Foldable Adjustable Suction Cup Phone Stand [89+LBS Suction & 2800gf Magnetic] for Car Accessories iPhone17/16

OHLPRO Tablet Car Mount Universal Tablet Holder for Car Windshield Dash Dashboard, 360 Degree Rotation,TPU Suction Gel Stick, for iPad Mini 4/3/2/1Samsung Galaxy Size 7"- 10.5" Tablet Mount