Received: from maia.hub.org (unknown [200.46.204.183]) by mail.postgresql.org (Postfix) with ESMTP id 80F4A6328A2 for ; Mon, 9 Nov 2009 10:35:08 -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 55808-04 for ; Mon, 9 Nov 2009 14:34:59 +0000 (UTC) X-Greylist: from auto-whitelisted by SQLgrey-1.7.6 Received: from smtp1.hi-media-techno.com (smtp1.hi-media-techno.com [195.158.241.85]) by mail.postgresql.org (Postfix) with ESMTP id 4AC5163321D for ; Mon, 9 Nov 2009 10:35:00 -0400 (AST) Received: from localhost (localhost [127.0.0.1]) by smtp1.hi-media-techno.com (Postfix) with ESMTP id 0020B3863C1; Mon, 9 Nov 2009 15:34:58 +0100 (CET) Received: from smtp1.hi-media-techno.com ([127.0.0.1]) by localhost (smtp1.backbone.hi-media-techno.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id au950ILWOOZc; Mon, 9 Nov 2009 15:34:57 +0100 (CET) Received: from mail1.hi-media-techno.com (unknown [192.168.27.17]) by smtp1.hi-media-techno.com (Postfix) with ESMTP id 60F8693B75; Mon, 9 Nov 2009 15:34:57 +0100 (CET) Received: from localhost (localhost.localdomain [127.0.0.1]) by mail1.hi-media-techno.com (Postfix) with ESMTP id 4B11168013; Mon, 9 Nov 2009 15:34:57 +0100 (CET) X-Virus-Scanned: amavisd-new at mail1.hi-media-techno.com Received: from mail1.hi-media-techno.com ([127.0.0.1]) by localhost (mail1.hi-media-techno.com [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id effdea-JV99U; Mon, 9 Nov 2009 15:34:57 +0100 (CET) Received: from dim (unknown [83.167.62.196]) by mail1.hi-media-techno.com (Postfix) with ESMTPSA id 2132068011; Mon, 9 Nov 2009 15:34:57 +0100 (CET) Received: by dim (Postfix, from userid 1000) id E9F7713F20; Mon, 9 Nov 2009 15:34:13 +0100 (CET) From: Dimitri Fontaine To: Brian Karlak Cc: pgsql-performance@postgresql.org Subject: Re: maintaining a reference to a fetched row Organization: Hi-Media References: <22AC581D-50D1-4863-9FDE-35EDDB171269@metaweb.com> Date: Mon, 09 Nov 2009 15:34:13 +0100 In-Reply-To: <22AC581D-50D1-4863-9FDE-35EDDB171269@metaweb.com> (Brian Karlak's message of "Tue, 3 Nov 2009 12:30:15 -0800") Message-ID: <87pr7r4viy.fsf@hi-media-techno.com> User-Agent: Gnus/5.13 (Gnus v5.13) Emacs/23.1.50 (gnu/linux) MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii 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/90 X-Sequence-Number: 36258 Brian Karlak writes: > I have a simple queuing application written on top of postgres which I'm > trying to squeeze some more performance out of. Have you tried to write a custom PGQ consumer yet? http://wiki.postgresql.org/wiki/PGQ_Tutorial Regards, -- dim