Skip to content

v3.18.0

Latest

Choose a tag to compare

@DZakh DZakh released this 21 Nov 06:17
b6246eb

What's Changed

Covering Indexes for Postgres

Adds include to the entity-level @index directive:

type Trade @index(fields: ["poolId", ["date", "DESC"]], include: ["volume"]) {
  id: ID!
  poolId: String!
  date: BigInt!
  volume: BigDecimal!
}

builds

CREATE INDEX "Trade_poolId_date_desc_..." ON "public"."Trade"("poolId", "date" DESC) INCLUDE ("volume");

The included columns are stored in the index but not searched or sorted by, so a query that reads only key and included columns is an index-only scan.

By @DenhamPreen in #1854

Other Fixes & Improvements

  • Better retries on RPC rate-limited responses by @DZakh in #1861
  • Fix edge case of skipping events when a contract is dynamically registered in different blocks by @DZakh in #1856
  • Fix query cache for HyperSync source by @DZakh in #1847
  • Architecture improvements and reduced addresses RAM 3.6x (5M addresses 835->230 MB) by @DZakh in #1850
  • Internal test framework improvements by @DZakh in #1844, #1849, #1848, #1853

Full Changelog: v3.17.1...v3.18.0