SELECT ps.*, emb.embedding_gemini_embedding_001 <=> (
SELECT ARRAY(SELECT random()::real FROM generate_series(1, 3072))::halfvec(3072)
) AS similarity
FROM paper AS ps
JOIN embedding AS emb
ON emb.paper_id = ps.paper_id
WHERE ps.update_date > '2020-01-01'
AND emb.embedding_gemini_embedding_001 IS NOT NULL
AND ((ps.source IN ('OSDI', 'SOSP', 'ASPLOS', 'ATC', 'NSDI', 'MLSys', 'EuroSys', 'VLDB')))
ORDER BY similarity ASC
LIMIT 10
SELECT ps.*, emb.embedding_gemini_embedding_001 <=> (
SELECT ARRAY(SELECT random()::real FROM generate_series(1, 3072))::halfvec(3072)
) AS similarity
FROM paper AS ps
JOIN embedding AS emb
ON emb.paper_id = ps.paper_id
WHERE ps.update_date > '2020-01-01'
AND emb.embedding_gemini_embedding_001 IS NOT NULL
AND ((ps.source IN ('OSDI', 'SOSP', 'ASPLOS', 'ATC', 'NSDI', 'MLSys', 'EuroSys', 'VLDB')))
ORDER BY similarity ASC
LIMIT 10