Chew on These Postgres “Hidden Gems”

The so-called gems were wide-ranging, touching on everything from hooks, indexing, search and to working with time in Postgres.
February 6, 2018

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.

Commencer gratuitement

Rejoignez les milliers d’entreprises qui utilisent Fivetran pour centraliser et transformer leur data.

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.
Data insights
Data insights

Chew on These Postgres “Hidden Gems”

Chew on These Postgres “Hidden Gems”

February 6, 2018
February 6, 2018
Chew on These Postgres “Hidden Gems”
The so-called gems were wide-ranging, touching on everything from hooks, indexing, search and to working with time in Postgres.

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.

Articles associés

No items found.
No items found.
BODi modernizes infrastructure to build customer 360
Blog

BODi modernizes infrastructure to build customer 360

Lire l’article
How Fan 360 redefines the sports landscape
Blog

How Fan 360 redefines the sports landscape

Lire l’article
How Customer 360 drives retail revenue
Blog

How Customer 360 drives retail revenue

Lire l’article

Commencer gratuitement

Rejoignez les milliers d’entreprises qui utilisent Fivetran pour centraliser et transformer leur data.

Thank you! Your submission has been received!
Oops! Something went wrong while submitting the form.