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

Re: Reviewers Guide to Deferred Transactions/TransactionGuarantee

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: ITAGAKI Takahiro <itagaki(dot)takahiro(at)oss(dot)ntt(dot)co(dot)jp>
Cc: Simon Riggs <simon(at)2ndquadrant(dot)com>, pgsql-patches(at)postgresql(dot)org
Subject: Re: Reviewers Guide to Deferred Transactions/TransactionGuarantee
Date: 2007-04-27 01:01:40
Message-ID: 200704270101.l3R11e419610@momjian.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-patches
Your patch has been added to the PostgreSQL unapplied patches list at:

	http://momjian.postgresql.org/cgi-bin/pgpatches

It will be applied as soon as one of the PostgreSQL committers reviews
and approves it.

---------------------------------------------------------------------------


ITAGAKI Takahiro wrote:
> "Simon Riggs" <simon(at)2ndquadrant(dot)com> wrote:
> 
> > > transaction_guarantee.v11.patch 
> > correct files attached
> 
> This is a small fix to transaction_guarantee patch.
> WAL writer needs PGSharedMemoryReAttach() on EXEC_BACKEND platforms.
> Other changes are only for suppressing warnings.
> 
> We might also need to increase NUM_AUXILIARY_PROCS (=3) for WAL writer,
> but I didn't change it in the patch. (I don't know why the value is 3
> -- bgwriter, autovacuum launcher and ... what?)
> 
> 
> BTW, the following TODO item comes to my mind:
> | Allow WAL traffic to be streamed to another server for stand-by replication
> We have to open sockets to another server when we want to stream WAL.
> If there were WAL writer, we can save the number of those sockets.
> 
> Regards,
> ---
> ITAGAKI Takahiro
> NTT Open Source Software Center
> 

[ Attachment, skipping... ]

> 
> ---------------------------(end of broadcast)---------------------------
> TIP 9: In versions below 8.0, the planner will ignore your desire to
>        choose an index scan if your joining column's datatypes do not
>        match

-- 
  Bruce Momjian  <bruce(at)momjian(dot)us>          http://momjian.us
  EnterpriseDB                               http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

In response to

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2007-04-27 01:05:51
Subject: Re: [HACKERS] CIC and deadlocks
Previous:From: Bruce MomjianDate: 2007-04-27 01:00:27
Subject: Re: Reviewers Guide to Deferred Transactions/TransactionGuarantee

pgsql-patches by date

Next:From: Bruce MomjianDate: 2007-04-27 01:02:15
Subject: Re: non-recursive WITH clause support
Previous:From: Bruce MomjianDate: 2007-04-27 01:00:27
Subject: Re: Reviewers Guide to Deferred Transactions/TransactionGuarantee

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