About wahajali

wahajali

Hi, I'm trying to use the latest pgvector v0.6.0 Postgres extension on CloudSQL Postgres v15.5. At the time of HNSW index creation, I get the following errors: 2024-04-25 16:08:08.830 UTC [214]: [22-1] db=database,user=user ERROR: could not resize sh...

wahajali

Thanks for the reply. Actually I'm trying to benchmark pgvector across GCP, Azure and AWS. And while the configurations are working on both Azure and AWS, its failing on GCP. I agree that changing the `maintenance_work_mem` to a lower value will work...

wahajali

With `maintenance_work_mem = 3GB` the index build works fine, anything higher fails. I also tried with a larger instance but got the same error:8 vCPUs, 32G memmaintenance_work_mem = 15GBmax_parallel_maintenance_workers = 7

My Stats

cpeterson's Bio

Badges wahajali Earned

Recent Activity

CloudSQL for Postgres - Unable to Create HNSW Index with Latest pgvector 0.6.0

Re: CloudSQL for Postgres - Unable to Create HNSW Index with Latest pgvector 0.6.0

Re: CloudSQL for Postgres - Unable to Create HNSW Index with Latest pgvector 0.6.0