Re: [HACKERS] Idea: Always consistent in-database cache using SSI mechanisms

2011-10-25 Thread Magnus Hagander
On Tue, Oct 25, 2011 at 00:00, Alexander Korotkov wrote: > On Tue, Oct 25, 2011 at 1:46 AM, Kevin Grittner > wrote: >> >> Alexander Korotkov wrote: >> >> > Coundn't be predicate locking implementation in SSI be used for >> > in-database cache invalidation. >> >> It would not necessarily be limit

Re: [HACKERS] Idea: Always consistent in-database cache using SSI mechanisms

2011-10-24 Thread Alexander Korotkov
On Tue, Oct 25, 2011 at 1:46 AM, Kevin Grittner wrote: > Alexander Korotkov wrote: > > > Coundn't be predicate locking implementation in SSI be used for > > in-database cache invalidation. > > It would not necessarily be limited to *in-database* caches. The > main thing would be to design a goo

Re: [HACKERS] Idea: Always consistent in-database cache using SSI mechanisms

2011-10-24 Thread Kevin Grittner
Alexander Korotkov wrote: > Coundn't be predicate locking implementation in SSI be used for > in-database cache invalidation. It would not necessarily be limited to *in-database* caches. The main thing would be to design a good API to the predicate locking portion of SSI, which I think is abo

[HACKERS] Idea: Always consistent in-database cache using SSI mechanisms

2011-10-24 Thread Alexander Korotkov
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 a