pgvector.git / summary / log / commit / refs

commit    67eec4edbf1cd4e8f6dfe2ec906103a83f6d3e0d
Author:   Andrew Kane <andrew@ankane.org>
Date:     Thu Mar 28 05:04:28 2024 +0000

    Improved tuning section [skip ci]


 README.md | 14 +++++++++++++-
 1 file changed, 13 insertions(+), 1 deletion(-)

diff --git a/README.md b/README.md
index 529cae6d..f9849c81 100644
--- a/README.md
+++ b/README.md
@@ -415,7 +415,19 @@ You can use [Reciprocal Rank Fusion](https://github.com/pgvector/pgvector-python
 
 ### Tuning
 
-Use a tool like [PgTune](https://pgtune.leopard.in.ua/) to set initial values for Postgres server parameters.
+Use a tool like [PgTune](https://pgtune.leopard.in.ua/) to set initial values for Postgres server parameters. For instance, `shared_buffers` should typically be 25% of the server’s memory. You can find the config file with:
+
+```sql
+SHOW config_file;
+```
+
+And check individual settings with:
+
+```sql
+SHOW shared_buffers;
+```
+
+Be sure to restart Postgres for changes to take effect.
 
 ### Loading
 


[parent: 396090d8e072]