search

pg-redis-fdw / redis_fdw

A PostgreSQL foreign data wrapper for Redis
497 stars 68 forks source link

Cache expire? #13

Closed gspiegelberg closed 8 years ago

gspiegelberg commented 8 years ago

Is there a way to set keys to expire in redis via this FDW?

adunstan commented 8 years ago

No, they are pretty much treated as persistent values. Its would be possible to set a timeout as a table option and implement that fairly easily, but I'm sure how much value that would be. There is a postgres wrapper around the hiredis API that would let you expire keys. It can be cloned from https://bitbucket.org/IVC-Inc/redis_wrapper.git