Re: queries on xmin

Поиск
Список
Период
Сортировка
От Marko Kreen
Тема Re: queries on xmin
Дата
Msg-id e51f66da0906110648j4d786373j2b818a20fff6277f@mail.gmail.com
обсуждение исходный текст
Ответ на Re: queries on xmin  (Matt Amos <zerebubuth@gmail.com>)
Ответы Re: queries on xmin  (Matt Amos <zerebubuth@gmail.com>)
Список pgsql-general
On 6/11/09, Matt Amos <zerebubuth@gmail.com> wrote:
> On Thu, Jun 11, 2009 at 1:13 PM, Brett Henderson<brett@bretth.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

В списке pgsql-general по дате отправления:

Предыдущее
От: Andy Colson
Дата:
Сообщение: Re: Libpq on windows
Следующее
От: Vick Khera
Дата:
Сообщение: Re: help with data recovery from injected UPDATE