Postgres Weekly curator Craig Kerstiens asked his Twitter followers about their favorite hidden gems in Postgres, leading to a blog post featuring over two dozen tips on various aspects such as hooks, indexing, search and working with time. Fivetran, a company that uses Postgres for its production database, can sync and replicate your company's Postgres data, store it as an analytics database, or pull it as a data source. As businesses grow, they may need to switch to columnar warehouses like Snowflake, Google BigQuery, and Redshift for more advanced analytics.