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

Re: [GENERAL] [HACKERS] Hot Standby utility and administratorfunctions

From: Simon Riggs <simon(at)2ndQuadrant(dot)com>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Alvaro Herrera <alvherre(at)commandprompt(dot)com>, Robert Haas <robertmhaas(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>, pgadmin-hackers(at)postgresql(dot)org, pgsql-general(at)postgresql(dot)org
Subject: Re: [GENERAL] [HACKERS] Hot Standby utility and administratorfunctions
Date: 2008-10-21 07:05:42
Message-ID: 1224572742.3808.889.camel@ebony.2ndQuadrant (view raw or flat)
Thread:
Lists: pgadmin-hackerspgsql-generalpgsql-hackers
On Mon, 2008-10-20 at 18:45 -0400, Tom Lane wrote:
> Simon Riggs <simon(at)2ndQuadrant(dot)com> writes:
> > On Mon, 2008-10-20 at 17:44 -0300, Alvaro Herrera wrote:
> >> That's been "extended with an epoch counter" per the docs; I don't think
> >> that's appropriate for the new functions, is it?
> 
> > I assumed it was, so you can subtract them easily. 
> 
> > It can be done either way, I guess. Happy to provide what people need. I
> > just dreamed up a few that sounded useful.
> 
> I don't think you should be inventing new functions without clear
> use-cases in mind.  Depending on what the use is, I could see either the
> xid or the txid definition as being *required*.

The use case for the two functions was clearly stated as "together
allows easy arithmetic on xid difference between master and
slave". In that context, xid plus epoch is appropriate.

There are other use cases. We can have both, neither or just one,
depending upon what people think. What would you want "xid only" for? Do
you think that should replace the txid one?

This is everybody's opportunity to say what we need.

> In any case, do not use the wrong return type for the definition you're
> implementing.

err...Why would anyone do that?

-- 
 Simon Riggs           www.2ndQuadrant.com
 PostgreSQL Training, Services and Support


In response to

Responses

pgsql-hackers by date

Next:From: Zeugswetter Andreas OSB sITDate: 2008-10-21 07:44:40
Subject: Re: [HACKERS] Hot Standby utility and administrator functions
Previous:From: Chuck McDevittDate: 2008-10-21 06:28:57
Subject: Re: Multi CPU Queries - Feedback and/or suggestions wanted!

pgadmin-hackers by date

Next:From: Zeugswetter Andreas OSB sITDate: 2008-10-21 07:44:40
Subject: Re: [HACKERS] Hot Standby utility and administrator functions
Previous:From: Gevik BabakhaniDate: 2008-10-20 22:59:08
Subject: Re: extending functionality strategy

pgsql-general by date

Next:From: Zeugswetter Andreas OSB sITDate: 2008-10-21 07:44:40
Subject: Re: [HACKERS] Hot Standby utility and administrator functions
Previous:From: tomasDate: 2008-10-21 06:06:12
Subject: Re: [HACKERS] Debian no longer dumps cores?

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