pg_filedump icon indicating copy to clipboard operation
pg_filedump copied to clipboard

Published 20 hours ago • verified publisher icon df7cb

vector data

Open FlynnHuang8 opened this issue 2 years ago • 4 comments

Can you support parsing of -D vector, i.e. vector data?

FlynnHuang8 avatar Sep 08 '23 06:09 FlynnHuang8

Hi, I guess you mean https://github.com/pgvector/pgvector ?

What's the use case for pg_filedump here? Non-core datatypes would best be extracted by getting PostgreSQL to run on the data directory, and just SELECTing the data.

df7cb avatar Sep 14 '23 12:09 df7cb

When I build a vector index using pgvector, I want to use pg_dump to export the data and see the index structure, but it doesn't parse the HNSW index correctly, it would be great if it could support exporting!

FlynnHuang8 avatar Sep 15 '23 02:09 FlynnHuang8

pg_dump won't look inside indexes.

If you want to look into page structures, try the pageinspect extension.

df7cb avatar Sep 15 '23 07:09 df7cb

Fwiw if someone submits a PR for hnsw index support, I wouldn't be opposed to merging it, but that's probably better handled first with in-PostgreSQL extensions.

df7cb avatar Sep 15 '23 07:09 df7cb