Skip site navigation (1) Skip section navigation (2)

2nd Level Buffer Cache

From: Radosław Smogura <rsmogura(at)softperience(dot)eu>
To: PG Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: 2nd Level Buffer Cache
Date: 2011-03-17 19:47:03
Message-ID: 201103172047.03556.rsmogura@softperience.eu (view raw or flat)
Thread:
Lists: pgsql-hackers
Hi,

I have implemented initial concept of 2nd level cache. Idea is to keep some 
segments of shared memory for special buffers (e.g. indices) to prevent 
overwrite those by other operations. I added those functionality to nbtree 
index scan.

I tested this with doing index scan, seq read, drop system buffers, do index 
scan and in few places I saw performance improvements, but actually, I'm not 
sure if this was just "random" or intended improvement.

There is few places to optimize code as well, and patch need many work, but 
may you see it and give opinions?

Regards,
Radek

Attachment: 2nd_lvl_cache.diff
Description: text/x-patch (28.1 KB)

Responses

pgsql-hackers by date

Next:From: Jesper KroghDate: 2011-03-17 20:02:58
Subject: Re: really lazy vacuums?
Previous:From: Robert HaasDate: 2011-03-17 19:39:19
Subject: Re: Allowing multiple concurrent base backups

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group