Re: maintaining a reference to a fetched row

From: Brian Karlak <zenkat(at)metaweb(dot)com>
To: Craig Ringer <craig(at)postnewspapers(dot)com(dot)au>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: maintaining a reference to a fetched row
Date: 2009-11-04 00:12:44
Message-ID: B531CFC7-0DF2-46DF-B9F2-C6AC97816933@metaweb.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message David Kerr 2009-11-04 00:18:25 Re: Optimizer + bind variables
Previous Message Craig Ringer 2009-11-04 00:03:48 Re: maintaining a reference to a fetched row