The PostgreSQL online store provides support for materializing feature values into a PostgreSQL database for serving online features.
- Only the latest feature values are persisted
- sslmode, sslkey_path, sslcert_path, and sslrootcert_path are optional
In order to use this online store, you'll need to run
pip install 'feast[postgres]'. You can get started by then running
feast init -t postgres.
The set of functionality supported by online stores is described in detail here. Below is a matrix indicating which functionality is supported by the Postgres online store.
write feature values to the online store
read feature values from the online store
update infrastructure (e.g. tables) in the online store
teardown infrastructure (e.g. tables) in the online store
generate a plan of infrastructure changes
support for on-demand transforms
readable by Python SDK
readable by Java
readable by Go
support for entityless feature views
support for concurrent writing to the same key
support for ttl (time to live) at retrieval
support for deleting expired data
collocated by feature view
collocated by feature service
collocated by entity key
To compare this set of functionality against other online stores, please see the full functionality matrix.