Skip to content
Snippets Groups Projects
  1. Aug 20, 2024
  2. Aug 19, 2024
  3. Aug 16, 2024
  4. Aug 15, 2024
    • Daniel Bimschas's avatar
      HOLI-9524: use index and fix distance calculation · d34b474f
      Daniel Bimschas authored
      * query now (implicitly) uses the HNSW index on embedding_array
      * query now uses the `<#>` operator to sort by distance which can (and will) take advantage of the
        index for the newly introduced `location_gps` column which combines (`longitude`,`latitude`) into
        a PostGIS geometry
      * distance calculation is fixed - it calculated before with two different units (distance in
        "angle" (RSID 4326) vs. distance in meters (RSID 3857, Pseudo-Mercator plane projection))
      d34b474f
  5. Aug 14, 2024
  6. Aug 13, 2024
  7. Aug 12, 2024
  8. Aug 09, 2024
  9. Aug 08, 2024
  10. Aug 06, 2024
Loading