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

Re: Acclerating INSERT/UPDATE using UPS

From: Hideyuki Kawashima <kawasima(at)cs(dot)tsukuba(dot)ac(dot)jp>
To: Bruce Momjian <bruce(at)momjian(dot)us>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Acclerating INSERT/UPDATE using UPS
Date: 2007-04-03 03:49:27
Message-ID: 4611CEC7.7060502@cs.tsukuba.ac.jp (view raw or flat)
Thread:
Lists: pgsql-hackers
I will write a technical document about Sigres in a week.

Hideyuki

Bruce Momjian wrote:
> I am still unclear why sigres is better than a temporary file system.  I
> relize your patch is faster, but what is about your patch that makes it
> faster.
>
> And if we were going to add such capability, we would name it based on
> what it does, rather than on a 'sigres' mode.
>
> ---------------------------------------------------------------------------
>
> Hideyuki Kawashima wrote:
>   
>> Simon,
>>
>>     
>>> Not checkpointing at all is not a good plan, since this will lead to an
>>> enormous build up of WAL files and a very long recovery time if the
>>> system does fail.
>>>       
>> I appreciate your detailed comments.
>> Following your comments, I revised the problem.
>> Sigres-0.1.3 does checkpointings.
>>
>> In summary, the features of Sigres-0.1.3 are as follows.
>> 0: 10% faster than conventional PostgreSQL under tmpfs.
>> 1: Checkpointings are continually executed.
>> 2: Sigres mode is in default (the mode can be turned off via postgresql.conf).
>> 3: issue_xlog_sync is called only by bgwriter (continually, via
>> createcheckpoint)
>> 4: The entity of XLogWrite (_XLogWrite in my code) is called by both
>> backends and a bgwriter.
>> For each backend, _XLogWrite is called only via AdvanceXLInsertBuffer.
>> For a bgwriter, _XLogWrite is called via CreateCheckPoint.
>>
>> Please try it if you have interest.
>> http://sourceforge.jp/projects/sigres/
>>
>> Again, I really appreciate beneficial comments from this community !
>>
>> Regards,
>>
>> -- Hideyuki
>>
>> --
>> Hideyuki Kawashima (Ph.D.)
>> University of Tsukuba
>> Assistant Professor
>>
>> ---------------------------(end of broadcast)---------------------------
>> TIP 3: Have you checked our extensive FAQ?
>>
>>                http://www.postgresql.org/docs/faq
>>     
>
>   

-- 
Hideyuki Kawashima (Ph.D), University of Tsukuba,
Graduate School of Systems and Information Engineering
Assistant Professor, TEL: +81-29-853-5322



In response to

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2007-04-03 04:12:07
Subject: Re: Feature thought: idle in transaction timeout
Previous:From: Tom LaneDate: 2007-04-03 02:39:26
Subject: Re: Feature thought: idle in transaction timeout

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