Check out pgvector: https://github.com/ankane/pgvector (disclosure: am author)

It uses IVFFlat indexing, but could be extended to support product quantization / ScaNN.