Re: queries on xmin

From: Marko Kreen <markokr(at)gmail(dot)com>
To: Matt Amos <zerebubuth(at)gmail(dot)com>
Cc: Brett Henderson <brett(at)bretth(dot)com>, pgsql-general(at)postgresql(dot)org
Subject: Re: queries on xmin
Date: 2009-06-11 13:48:48
Message-ID: e51f66da0906110648j4d786373j2b818a20fff6277f@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 6/11/09, Matt Amos <zerebubuth(at)gmail(dot)com> wrote:
> On Thu, Jun 11, 2009 at 1:13 PM, Brett Henderson<brett(at)bretth(dot)com> wrote:
> >> See pgq.batch_event_sql() function in Skytools [2] for how to
> >> query txids between snapshots efficiently and without being affected
> >> by long transactions.
> >
> > I'll take a look.
>
> it was looking at the skytools stuff which got me thinking about using
> txids in the first place. someone on the osm-dev list had suggested
> using PgQ, but we weren't keen on the schema changes that would have
> been necessary.

Except the trigger, PgQ does not need any schema changes?

--
marko

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Andy Colson 2009-06-11 13:53:15 Re: Libpq on windows
Previous Message Andy Colson 2009-06-11 13:47:52 Re: Libpq on windows