Bridge for Analytics is a hybrid database system that provides solutions for dealing with large data volumes in PostgreSQL. It allows for easy data copying and transformation into a data lake for cheaper storage and efficient analytical queries. Time-partitioned tables and compressed Parquet files in S3 are used to optimize performance. The process includes setting up partitioned tables, copying data into an analytics table, and running fast analytical queries on historical data.
Table of contents
Setting up a time-partitioned table for fast writes and lookup queriesCopying data into a lake analytics table for cheap storage and fast analyticsCopying data into your analytics tableRunning fast analytical queries on our historical dataGet started with Crunchy Bridge for AnalyticsSort: