Re: maintaining a reference to a fetched row

Поиск
Список
Период
Сортировка
От Brian Karlak
Тема Re: maintaining a reference to a fetched row
Дата
Msg-id 10FE20B6-051E-4E26-9B69-33D39F589125@metaweb.com
обсуждение исходный текст
Ответ на Re: maintaining a reference to a fetched row  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-performance
On Nov 3, 2009, at 9:31 PM, Tom Lane wrote:

> Brian Karlak <zenkat@metaweb.com> writes:
>> My question is this: is there some way that I can keep a cursor /
>> pointer / reference / whatever to the row I fetched originally, so
>> that I don't have to search for it again when I'm ready to write
>> results?
>
> If you don't expect any updates to the row meanwhile, ctid might
> serve.

Ahhh ... that's the magic I'm looking for.  Thanks!

Brian

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

Предыдущее
От: Anj Adu
Дата:
Сообщение: Re: High Frequency Inserts to Postgres Database vs Writing to a File
Следующее
От: Brian Karlak
Дата:
Сообщение: Re: maintaining a reference to a fetched row