---
title: "Discussion on \"Why I Use Materialized Views for Job Board Aggregations\" | Hashnode"
description: "Discussion on \"Why I Use Materialized Views for Job Board Aggregations\". Keeping p95 queries ~50ms while 7,556 jobs update daily in Postgres"
url: "https://hashnode.com/posts/why-i-use-materialized-views-for-job-board-aggregations/69725f0f364e4632ab927b5c"
---

[Feed](https://hashnode.com/feed) /

Discussion

# [Why I Use Materialized Views for Job Board Aggregations](https://blog.dvskr.dev/why-i-use-materialized-views-for-job-board-aggregations?utm_source=hashnode&utm_medium=feed)

Keeping p95 queries ~50ms while 7,556 jobs update daily in Postgres

Jan 22 · 8 min read · blog.dvskr.dev  
Read the article

## Written by

[Sathish](https://hashnode.com/@sathish-daggula)

@sathish-daggula · Saint Louis

  
[View profile](https://hashnode.com/@sathish-daggula)

Data Engineer building products in public with AI

Data Engineer by day, indie hacker by night. Creator of pmhnphiring.com, building a gym tracker next. Shipping solo and writing about every win and fail. Building in public .

## Responses

Markdown supported · ⌘↵ to post

No responses yet.
