Received: from localhost (unknown [200.46.204.187]) by postgresql.org (Postfix) with ESMTP id B5E259FA05C for ; Mon, 8 Oct 2007 14:10:24 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.187]) (amavisd-maia, port 10024) with ESMTP id 70806-01-5 for ; Mon, 8 Oct 2007 14:10:18 -0300 (ADT) X-Greylist: from auto-whitelisted by SQLgrey-1.7.5 Received: from service-web.de (p15093784.pureserver.info [217.160.106.224]) by postgresql.org (Postfix) with ESMTP id 210C19FA235 for ; Mon, 8 Oct 2007 14:10:19 -0300 (ADT) Received: from [192.168.178.22] (p548B2142.dip0.t-ipconnect.de [84.139.33.66]) by service-web.de (Postfix) with ESMTP id 2D234E82ED; Mon, 8 Oct 2007 19:10:06 +0200 (CEST) Message-ID: <470A645C.1080405@wildenhain.de> Date: Mon, 08 Oct 2007 19:09:48 +0200 From: Tino Wildenhain User-Agent: Thunderbird 2.0.0.6 (Windows/20070728) MIME-Version: 1.0 To: Magnus Hagander Cc: Jeff@PointHere.net, "'D'Arcy J.M. Cain'" , pgsql-performance@postgresql.org Subject: Re: Apache2 PostgreSQL http authentication References: <200710080812110000@463712056> In-Reply-To: <200710080812110000@463712056> Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200710/81 X-Sequence-Number: 27103 Magnus Hagander schrieb: > I'd consider having a small daemon LISTENing for NOTIFYs that you send by triggers whenever the table has changed. That'll make sure it only dumps if something actually changed. And you can also implement some ratelimiting if needed. Do you really think such a homegrown solution will be more performant then just accessing postgres? If you have many users the lookup time in a .htaccess/.htpasswd is not for free either. Regards Tino