Re: maintaining a reference to a fetched row - Mailing list pgsql-performance

From Brian Karlak
Subject Re: maintaining a reference to a fetched row
Date
Msg-id B531CFC7-0DF2-46DF-B9F2-C6AC97816933@metaweb.com
Whole thread Raw
In response to Re: maintaining a reference to a fetched row  (Craig Ringer <craig@postnewspapers.com.au>)
List pgsql-performance
On Nov 3, 2009, at 4:03 PM, Craig Ringer wrote:

> I don't have a good answer for you there. Perhaps using Pg's locking
> to
> do your queueing, rather than updating a status flag, might let you
> use
> a cursor? Have a look at the list archives - there's been a fair bit
> of
> discussion of queuing mechanisms.

This is an interesting idea.  I'll see what I can find in the
archives.  It will likely take a bit of refactoring, but such is
life ...

Thanks!
Brian

pgsql-performance by date:

Previous
From: Craig Ringer
Date:
Subject: Re: maintaining a reference to a fetched row
Next
From: David Kerr
Date:
Subject: Re: Optimizer + bind variables