Troubleshooting

Workers Not Starting

1. Verify shared_preload_libraries:

   SHOW shared_preload_libraries;
   

2. Check PostgreSQL logs for errors

3. Ensure proper permissions on API key file

Slow Processing

1. Increase workers:

   ALTER SYSTEM SET pgedge_vectorizer.num_workers = 4;
   -- Requires restart
   

2. Increase batch size:

   ALTER SYSTEM SET pgedge_vectorizer.batch_size = 20;
   SELECT pg_reload_conf();
   

Failed Embeddings

1. Check API key is valid
2. Verify network connectivity

3. Review error messages:

   SELECT * FROM pgedge_vectorizer.failed_items;
   

4. Retry failed items:

   SELECT pgedge_vectorizer.retry_failed();