Postgres Pro
Downloads
Home   >   mailing lists

Idea: Always consistent in-database cache using SSI mechanisms - Mailing list pgsql-hackers

From Alexander Korotkov
Subject Idea: Always consistent in-database cache using SSI mechanisms
Date
Msg-id CAPpHfdugCegzxU+nX1wnngQ2Rjxxd=RMoyhBj8u+gSRrwbg42w@mail.gmail.com
Whole thread Raw
Responses Re: Idea: Always consistent in-database cache using SSI mechanisms  ("Kevin Grittner" <Kevin.Grittner@wicourts.gov>)
List pgsql-hackers
Tree view
Hackers,

After Hekki's talk on PgConf.EU about SSI, some idea comes to my mind. Coundn't be predicate locking implementation in SSI be used for in-database cache invalidation.
It could be possible to implement in-database cache which will acquire predicate locks like SSI transactions. In case of any conflich with other transactions corresponding cache invalidates. Therefore, it might be possible to get acceleration of caching without risk of inconsistent answers.
Actually, I don't understand SSI in details. So, probably I mess up things. Does my idea any matter?

------
With best regards,
Alexander Korotkov. 

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: So, is COUNT(*) fast now?
Next
From: "Kevin Grittner"
Date:
Subject: Re: Idea: Always consistent in-database cache using SSI mechanisms