pgvector.git / summary / log / commit / refs

commit    183d50bdbdcfdf1162cb8cc50c581998700fd372
Author:   Andrew Kane <andrew@ankane.org>
Date:     Sat Mar 16 17:45:09 2024 +0000

    Added note about creating indexes concurrently [skip ci]


 README.md | 6 ++++++
 1 file changed, 6 insertions(+)

diff --git a/README.md b/README.md
index 7f0e874e..7b7e1ad2 100644
--- a/README.md
+++ b/README.md
@@ -428,6 +428,12 @@ Add any indexes *after* loading the initial data for best performance.
 
 See index build time for [HNSW](#index-build-time) and [IVFFlat](#index-build-time-1).
 
+In production environments, create indexes concurrently to avoid blocking writes.
+
+```sql
+CREATE INDEX CONCURRENTLY ...
+```
+
 ### Querying
 
 Use `EXPLAIN ANALYZE` to debug performance.


[parent: bd776fee68b2]