omnicache-postgres-conference-2024-san-jose

Part of "Postgres can do WHAT?" presentation.

1. Postgres can do WHAT?POSTGRES CONFERENCE 2024

2. omni_cache
Application Accelerator

3. Why?
Data-intensive applications that use Postgres suffer from increased latency
when they execute complex queries.

4. How is it being solved today?
Dedicated Cache
Built-in Cache
Read Replicas
Caching Proxies

5. Features of Omnicache
Granular Caching
re-use cache from different queries
Low TCO
Automatic cache invalidation
Postgres-Native
Supports Stored Procedure
Deployed as an extension

6. Demo

7. Good usecases?
Data Volume
Computation
Performance
POC

8. Other extensions
omni
omni_aws
omni_json
omni_seq
omni_txn
omni_vfs
pg_yregress
…

9. Learn More
WebsiteDiscordGithub

10. Questions

11. Thanks