Postgres PGVector Store × AmbactiBring Postgres PGVector Store into
the flow of work.
A little less busywork with Postgres PGVector Store.
Gather contextDo the workReview & share
Vectors5 capabilities+
- Insert vectors into a PostgreSQL table
- Bulk-load vectors with COPY
- Upsert vectors by row ID
- Update stored vectors
- Delete vector rows
Similarity search4 capabilities+
- Find nearest neighbors using L2 distance
- Find nearest neighbors using cosine distance or inner product
- Find rows within a distance threshold
- Calculate average vectors
Indexes2 capabilities+
- Create an HNSW approximate-neighbor index
- Create an IVFFlat approximate-neighbor index
Frequently asked
questions.
What could an Ambacti integration do with Postgres PGVector Store?
The documented operations include Vectors: Insert vectors into a PostgreSQL table; Vectors: Bulk-load vectors with COPY; Vectors: Upsert vectors by row ID; Vectors: Update stored vectors.
Could I keep a workflow read-only?
For a read-only workflow, limit account permissions to reading data and exclude actions that create, update, or delete records.
Will every action run automatically?
Choose which steps could run on their own and which should pause for review. Changes should follow the permissions and approval rules you set.
Do I need to review actions in Postgres PGVector Store?
Decide which work could run on its own and which steps need your review.