Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 5D355634008 for ; Tue, 3 Nov 2009 20:15:07 -0400 (AST) Received: from mail.postgresql.org ([200.46.204.86]) by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia, port 10024) with ESMTP id 48078-06 for ; Wed, 4 Nov 2009 00:14:59 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from mx01.metaweb.com (mx01.metaweb.com [208.68.111.25]) by mail.postgresql.org (Postfix) with SMTP id 999746351BD for ; Tue, 3 Nov 2009 20:14:59 -0400 (AST) Received: from zimbra01.corp.sjc1.metaweb.com (localhost [127.0.0.1]) by mx01.metaweb.com (Spam Firewall) with ESMTP id BE958181AE8; Tue, 3 Nov 2009 16:12:49 -0800 (PST) Received: from zimbra01.corp.sjc1.metaweb.com ([172.29.253.13]) by mx01.metaweb.com with ESMTP id yusggkLs9RnSCZTG; Tue, 03 Nov 2009 16:12:49 -0800 (PST) Received: from localhost (localhost.localdomain [127.0.0.1]) by zimbra01.corp.sjc1.metaweb.com (Postfix) with ESMTP id 8E9D0160D3CC; Tue, 3 Nov 2009 16:12:44 -0800 (PST) X-Virus-Scanned: amavisd-new at zimbra01.corp.sjc1.metaweb.com Received: from zimbra01.corp.sjc1.metaweb.com ([127.0.0.1]) by localhost (zimbra01.corp.sjc1.metaweb.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id S-61RfAZXO2I; Tue, 3 Nov 2009 16:12:44 -0800 (PST) Received: from dhcp-wired-053.corp.631h.metaweb.com (dhcp-wired-053.corp.631h.metaweb.com [172.31.20.53]) by zimbra01.corp.sjc1.metaweb.com (Postfix) with ESMTP id 61546160C097; Tue, 3 Nov 2009 16:12:44 -0800 (PST) Cc: pgsql-performance@postgresql.org Message-Id: From: Brian Karlak To: Craig Ringer In-Reply-To: <4AF0C4E4.2080902@postnewspapers.com.au> Content-Type: text/plain; charset=US-ASCII; format=flowed; delsp=yes Content-Transfer-Encoding: 7bit Mime-Version: 1.0 (Apple Message framework v936) Subject: Re: maintaining a reference to a fetched row Date: Tue, 3 Nov 2009 16:12:44 -0800 References: <22AC581D-50D1-4863-9FDE-35EDDB171269@metaweb.com> <4AF0C4E4.2080902@postnewspapers.com.au> X-Mailer: Apple Mail (2.936) X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=-2.599 tagged_above=-10 required=5 tests=BAYES_00=-2.599 X-Spam-Level: X-Archive-Number: 200911/35 X-Sequence-Number: 36203 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