Chew on these Postgres “Hidden Gems”

Craig Kerstiens curates the email newsletter Postgres Weekly, and he heads the cloud team at Citus Data. He took to Twitter the other day, asking followers: “What’s your favorite hidden gem of Postgres that you wish more people knew about?”

The response was overwhelming. In a blog post, Kerstiens published more than two dozen tips about the object-oriented database. The so-called gems were wide-ranging, touching on everything from hooks, indexing, search and to working with time in Postgres.

Got any more “hidden gems” to share with us?

Here at Fivetran, we’re heavy Postgres users. We employ it for our production database, on Amazon RDS. George Fraser, the CEO of Fivetran, will be speaking April 18 at PostgresConf US 2018 in Jersey City.

As part of our sales offerings of data pipelines, Fivetran can sync and replicate your company’s Postgres production data for you. Fivetran can also store your company data in Postgres as an analytics database. In short, we can pull it as a data source or deliver it as a destination. That said, as your business grows, you’ll want to switch to a columnar warehouse for performing more advanced analytics.

Fivetran replicates and syncs data from your supported cloud applications, databases, event logs, file stores and more. The three columnar warehouses we support and recommend include Snowflake, Google BigQuery and Redshift.

About Fivetran: Built for the cloud, Fivetran is the smartest, fastest way to replicate and store data into your warehouse with zero configuration. Our ecosystem frees companies to easily join data sources and perform agile analytics with the business intelligence tools of their choice.