MMAP Buffers

From: Radosław Smogura <rsmogura(at)softperience(dot)eu>
To: PG Hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: MMAP Buffers
Date: 2011-04-15 10:32:37
Message-ID: ac8eade5f27608bed98d40c437b42dec@mail.softperience.eu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hello,

If I may, I want to share some concept to use mmap in PG. It's far, far
away from perfect, but it's keeps WAL before data. As well I crated
table, with index, inserted few values, and I done vacuum full on this
table. Db inits welcome from orginal sources.

Performance of read (if backend is loaded) is really good, query time
goes down from 450ms to about 410ms. Update may be slower - but work is
in progress (I will start with write, as I went to point when simple
updates may be performed). Even that I didn't covered all aspects off
updating, it's simple to do it, just to call PreopareBufferToUpdate
before modifing buffer, ofc some ideas of increasing this are still in
my head.

Any comments, suggestions welcome.

I didn't included this, as diff, because of ~150kb size (mainly
configure scripts, which are included in SVC). Due to this, You may
download it from
http://softperience.eu/downloads/pg_mmap_20110415.diff.bz2 (Legal: Work
under PostgreSQL BSD Lincense). Patch is just GIT diff, later I will try
to grab some git.

Regards and have a nice day,
Radek.

P.S. This problem about assert with signals, I wrote... I merged with
last master, and rebuilded code. I think, I forgot to rebuild it after
previous merge.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Heikki Linnakangas 2011-04-15 11:33:37 Re: MMAP Buffers
Previous Message Thom Brown 2011-04-15 09:48:32 Re: Foreign table permissions and cloning