Skip to content

Latest commit

 

History

History
99 lines (86 loc) · 5.26 KB

CHANGELOG.md

File metadata and controls

99 lines (86 loc) · 5.26 KB
Raw

CHANGELOG

Future release

Columnar-optimized vacuuming allows columnar tables to be compacted after updates and deletes without full rewrite, which will also improve peformance after vacuum. Auto-vacuum support combines recent inserts into a single stripe. A new column cache makes JOIN queries more efficient. Vector similarity search and data types are now available via pgvector.

  • default table access method is now columnar (#107)
  • add pgvector extension (#106)
  • add vacuum_full UDF (#93)
  • bugfix: vacuum udf could get into a look and overwrite stripes (#92)
  • add columnar decompressed chunk cache (#86)
  • bugfix: vacuum hanging indefinitely in some cases (#80)
  • bugfix: release memory during long sequential scans (#78)
  • add user function to allow for incremental vacuum and space reclamation (#71)
  • add support for postgres 15 (#75)
  • add columnar vacuum to combine latest stripe into 1 stripe (#51, #74)

0.3.0-alpha

This release adds update and delete support for columnar tables. Incremental materialized views are now available via pg_ivm.

  • add incremental materialized views (pg_ivm extension) (#67)
  • bugfix: WHERE clause with certain custom types (4f5b508)
  • add counts of deleted rows, optimize if no data has been deleted (c987c6e)
  • add columnar updates and deletes (f33b0bd, 4f939f4, f5e0cc1, 7e15b4c)

0.2.0-alpha

This release has huge gains for performance, bringing parallelization to columnar scans and vectorization of WHERE clauses.

  • upgrade to spilo 2.1-p9 (4e06ec5)
  • bugfix: memory leak when decompressing chunks (15193be)
  • bugfix: vectorization with NULL values (e35a429)
  • add vectorization of WHERE clauses when comparing to a const value (a470460)
  • add parallel execution with JOIN clauses (3370bf9)
  • add conversion from columnar to heap (d0db6a2)
  • add vectorization of WHERE clauses (0d41837)
  • add parallel execution (f399474)

0.1.0-alpha

The initial release focuses on adding several new FDWs and productionization work for our cloud service.

  • add parquet_s3_fdw (02d2253)
  • add multicorn2, s3csv_fdw, and gspreadsheet_fdw extensions (1d7cb47, a22ecdc)
  • add mysql_fdw extension (92ae91e, bc47d31)
  • add pgsql-http extension, but disable for spilo (dae1e07, 59b37be)
  • change to using the official postgres image as our base image; spilo is maintained for Hydra hosted service (fec064b)
  • add tests for upgrading from previous image to current image (#31)
  • move all functions into columnar schema
  • add user function to convert from heap to columnar
  • upgrade to spilo 2.1-p7 (#26)
  • use docker-compose to have a stable storage (#16)
  • add pg_cron extension (#15)
  • build Hydra with bake files (buildx bake) (#7)
  • add acceptance tests and CI
  • add Hydra to spilo image
  • change build scripts to allow columnar to build as standalone extension