How to cache a query response with Postgres?

Question

I have a database that syncs completely every 2 hours. All data is dropped and populated from the main data source.

I have some queries coming from client app, that have the same response for the current 2-hours dataset. So, if 100 clients run their apps, I will have to run this query 100 times for each of them, even though they don't differ.

How do I avoid running this real query against my database every time, but just keep its response somewhere and return it instead?

I think I can run this query after each sync and save to its own table then return from it.

What are other options, probably provided by Postgres itself?

Oulalahakabu · Accepted Answer · 2017-12-05 14:28:07Z

1

You should use something like redis to store the result or your query in memory. It comes with many clients. You can invalidate the result of this query when it's time to.

There are other memory caching like memcache, easy to install & to use.

Note these are specific to postgres.

answered Dec 5, 2017 at 14:28

Oulalahakabu

4893 silver badges6 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Nurettin Şenssabc Over a year ago

Databases like Postgres already do this, so there's no need to use Redis for it."

Collectives™ on Stack Overflow

How to cache a query response with Postgres?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related