What if you could use PostgreSQL to easily query your data lake in S3 with state-of-the-art analytics performance? Well now you can. Join us this Wednesday, May 15 at 12PM EST/9AM PT for a walkthrough of Crunchy Bridge for Analytics, from setting it up, to running high performance vectorized queries. Register for the webinar here.

Crunchy Bridge for Analytics: Your Data Lake in PostgreSQL

Crunchy Data's excited to announce a new analytics engine to read cloud object storage files like CSV, JSON, and Parquet with Postgres.

Syncing Postgres Partitions to Your Data Lake in Crunchy Bridge for Analytics

Marco shows how you can combine pg_partman and pg_cron on Bridge for Analytics to set up automated time-partitioning with long-term retention and fast analytics in your data lake.

Row Level Security for Tenants in Postgres

Craig shows you how to use Row Level Security to isolate and secure data in a multi-tenant application.

Building PostgreSQL Extensions: Dropping Extensions and Cleanup

David shares some tricks for cleaning up after dropped extensions. He goes through how to create a event trigger and function for cleaning up a pg_cron task built by an extension.

Auto-archiving and Data Retention Management in Postgres with pg_partman

Automatically archiving data can save you a ton of money and storage space. Keith shows you can set up data retention policies in Postgres using pg_partman.

Time Partitioning and Custom Time Intervals in Postgres with pg_partman

Keith shows off a variety of the time interval options when you create partitioned tables with pg_partman.

Upcoming events

Crunchy Data has team members at these upcoming events:

PyCon US, Pittsburg, May 17

PGConf.DEV, Vancouver, May 28

DjangoCon EU, Spain, June 5

PGDay France, June 11

Webinar: AI in Postgres: Exploring the Vector Extension Webinar, June 13