[extensions] add vectorchord supports

[DrummyFloyd]

Have an idea to improve PGO? We'd love to hear it! We're going to need some information from you to learn more about your feature requests.

Please be sure you've done the following:

• Provide a concise description of your feature request.
• Describe your use case. Detail the problem you are trying to solve.
• Describe how you envision that the feature would work.
• Provide general information about your current PGO environment.

Overview

Add VectorChord (vchord) and pgvector extensions to Crunchy Postgres images for vector similarity search.

Use Case

Applications like Immich (self-hosted photo management) require VectorChord for AI-powered search and facial recognition. Currently, users must build and maintain custom images to add these extensions, which adds operational overhead and makes it harder to stay up-to-date with Crunchy image releases.

VectorChord is the successor to pgvecto.rs (now deprecated) and is becoming a standard requirement for AI/ML workloads.

Desired Behavior

Provide images with VectorChord pre-installed, similar to how PostGIS images are offered:

https://docs.crunchybridge.com/extensions-and-languages

The image should include:

• pgvector (>= 0.7.0) — required dependency
• VectorChord (vchord)

Users could then configure it via:

spec:
  image: registry.developers.crunchydata.com/crunchydata/crunchy-postgres-vchord:ubi9-17.x-x
  config:
    parameters:
      shared_preload_libraries: "vchord"

References:

• VectorChord: https://github.com/tensorchord/VectorChord (Apache 2.0)
• Immich requirements: https://docs.immich.app/administration/postgres-standalone/
• https://github.com/immich-app/immich-charts/blob/main/README.md#installation

Environment

Tell us about your environment:

Please provide the following details:

• Platform: Kubernetes
• Platform Version: 1.35
• PGO Image Tag: ubi9-6.0.0-0
• Postgres Version 17
• Storage: pvc
• Number of Postgres clusters: 1

Additional Information

Please provide any additional information that may be helpful.