# A cron job for speeding up Postgres analytical queries

DevFeed: [A cron job for speeding up Postgres analytical queries](<https://devfeed.tech/articles/the-cron-job-that-will-speed-up-your-postgres-queries-100x-18683.md>)

Original publisher: [Read original article](<https://www.tinybird.co/blog/the-one-cron-job-that-will-speed-up-your-analytical-queries-in-postgres-a-hundred-fold>)

Author: Jorge Sancha

Published: 2019-10-14T00:00:00Z

Content type: tutorial

Language: en

Sources: [Tinybird](<https://devfeed.tech/sources/tinybird.md>)

Topics: [Optimization](<https://devfeed.tech/topics/optimization.md>)

Tags: [implement](<https://devfeed.tech/tags/implement.md>), [optimization](<https://devfeed.tech/tags/optimization.md>), [speed](<https://devfeed.tech/tags/speed.md>), [the-data-base](<https://devfeed.tech/tags/the-data-base.md>)

## AI overview

The article presents a cron-job-based optimization for Postgres analytical queries and claims it made analytics 100 times faster. It states that the optimization takes 10 minutes to implement.

## Source excerpt

One cron job made Postgres analytics 100x faster. Seriously. This optimization takes 10 minutes to implement.