Re: Interesting paper: Contention-Aware Lock Scheduling

2018-05-07 Thread AJG
Another interesting article from Jan 2018 (Tsinghua University and Microsoft Research) http://madsys.cs.tsinghua.edu.cn/publications/TS2018-liu.pdf DudeTx: Durable Transactions Made Decoupled "This paper presents DudeTx, a crash-consistent durable transaction system that avoids the drawbacks of

Re: Pluggable storage

2018-06-18 Thread AJG
@Amit Re: Vacuum etc. Chrome V8 just released this blog post around concurrent marking, which may be of interest considering how cpu limited the browser is. Contains benchmark numbers etc in post as well. https://v8project.blogspot.com/2018/06/concurrent-marking.html "This post describes the

Re: Global shared meta cache

2018-06-27 Thread AJG
Ideriha, Takeshi wrote > 2) benchmarked 3 times for each conditions and got the average result of > TPS. > |master branch | prototype | > proto/master (%) > > >

Re: Is zheap on track for PostgreSQL 12.0?

2019-02-06 Thread AJG
Hopefully someone checked out this academic paper, as the perf gains seem impressive on the surface.. http://madsys.cs.tsinghua.edu.cn/publications/TS2018-liu.pdf DudeTx: Durable Transactions Made Decoupled "This paper presents DudeTx, a crash-consistent durable transaction system that avoids

Re: LSM tree for Postgres

2020-08-15 Thread AJG
Dmitry Dolgov wrote >> On Tue, Aug 04, 2020 at 11:22:13AM +0300, Konstantin Knizhnik wrote: >> >> Then I think about implementing ideas of LSM using standard Postgres >> nbtree. >> >> We need two indexes: one small for fast inserts and another - big >> (main) index. This top index is small enough

Re: a path towards replacing GEQO with something better

2021-06-20 Thread AJG
Hi, I stumbled across this which may be of interest to this topic and GEQO alternative. The main creator/author of Neo and Bao (ML for Query Optimizer) Ryan Marcus (finishing Postdoc and looking for job) recently posted [1] about Bao for distributed systems. But what was interesting

Re: Improving connection scalability: GetSnapshotData()

2021-03-01 Thread AJG
Hi, Greatly appreciate if you could please reply to the following questions as time allows. I have seen previous discussion/patches on a built-in connection pooler. How does this scalability improvement, particularly idle connection improvements etc, affect that built-in pooler need, if any?