This is kind of a genius idea that can make your application extremely fast: Use a CDN for your database. ​ Think of it this way: ​ If the network is slow, cut it and bring the data with you. ​ Let's say you build and host an application in the cloud. Your system us... See more

My favorite thing about pg_parquet is that you can build sophisticated data pipelines directly from PostgreSQL, because it connects PostgreSQL to a universal data storage and exchange platform: S3. For instance, you can periodically (with pg_cron) copy your Postgres time partitions into compressed Parquet files in S3, a... See more