Guide & Resources
pgvector features
What you can do with pgvector, fully managed by Elestio.
What you can do with pgvector, fully managed by Elestio.
pgvector is an Open-source vector similarity search for Postgres. In this, you can store your vectors with the rest of your data. Supports: exact and approximate nearest neighbor search, single-precision, half-precision, binary, and sparse vectors, L2 distance, inner product, cosine distance, L1 distance, Hamming distance, and Jaccard distance, and any language with a Postgres client.
PostgreSQL is one of the most advanced open-source databases, with numerous data types and functions added over the years. Data types include: Primitives: Integer, Numeric, String, Boolean. Structured: Date/Time, Array, Range / Multirange, UUID. Document: JSON/JSONB, XML, Key-value (Hstore). Geometry: Point, Line, Circle, Polygon. Customizations: Composite, Custom Types.
PostgreSQL strives to conform to the ANSI-SQL:2008 standard, is fully ACID (Atomicity, Consistency, Isolation and Durability) compliant, and is well-known for its rock-solid referential and transactional integrity. Its data integrity features ensure only validated data is stored.
All files stored in the database are protected from reading by any account other than the superuser account. Authentication is ensured via: GSSAPI, SSPI, LDAP, SCRAM-SHA-256, Certificate, and more; a robust access-control system; column and row-level security; and multi-factor authentication with certificates.
PostgreSQL is extensible because its operation is catalog-driven, with stored functions and procedures; Procedural Languages (PL/PGSQL, Perl, Python, etc); SQL/JSON path expressions; foreign data wrappers; customizable storage interface for tables, and many extensions that provide additional functionality, including PostGIS.
Explore pgvector on Elestio
pgvector runs on a dedicated instance, with backups, monitoring, SSL and updates handled by Elestio. Learn more about the software and everything included with the managed service.
Overview, screenshots and key benefits of pgvector.
Everything Elestio manages for your pgvector instance.
Deploy pgvector on Elestio step by step.
Live prices for every cloud provider and region.
Join thousands of developers who trust Elestio for fully managed hosting. Up and running in minutes, on any cloud.