X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id A160352A1F for ; Tue, 19 Jul 2005 18:04:44 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 64453-06 for ; Tue, 19 Jul 2005 21:04:43 +0000 (GMT) Received: from wproxy.gmail.com (wproxy.gmail.com [64.233.184.200]) by svr1.postgresql.org (Postfix) with ESMTP id 3CC0D52A1B for ; Tue, 19 Jul 2005 18:04:42 -0300 (ADT) Received: by wproxy.gmail.com with SMTP id 37so1319439wra for ; Tue, 19 Jul 2005 14:04:44 -0700 (PDT) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references; b=MymnCGJhN6Bv75ENRG9Q+Mx6d8NLzAV0LS69KhL+S8rd3mCByjdOwVnTkH5sdkdydIwZpF4kvPdxFofU2bVJEIQVXbTvppSORwBdeE7vDOsK3SxnO4niQzbnwA+hvSzMZkjm1KVujB/3HzpA3XgzKM/Y77gNv6IA1z5pvWtUNts= Received: by 10.54.137.17 with SMTP id k17mr892461wrd; Tue, 19 Jul 2005 14:04:04 -0700 (PDT) Received: by 10.54.150.2 with HTTP; Tue, 19 Jul 2005 14:04:04 -0700 (PDT) Message-ID: <1efd553a050719140462d41468@mail.gmail.com> Date: Tue, 19 Jul 2005 17:04:04 -0400 From: Oliver Crosby Reply-To: Oliver Crosby To: Sven Willenberger Subject: Re: Looking for tips Cc: Dawid Kuroczko , Kevin Grittner , jd@commandprompt.com, pgsql-performance@postgresql.org In-Reply-To: <1121805961.3674.25.camel@lanshark.dmv.com> Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline References: <1efd553a0507191308219a098b@mail.gmail.com> <758d5e7f0507191319636afaa3@mail.gmail.com> <1efd553a050719132836c31b78@mail.gmail.com> <1121805961.3674.25.camel@lanshark.dmv.com> X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.061 tagged_above=0 required=5 tests=AWL, RCVD_BY_IP X-Spam-Level: X-Archive-Number: 200507/327 X-Sequence-Number: 13568 > since triggers work with COPY, you could probably write a trigger that > looks for this condition and does the ID processsing you need; you could > thereby enjoy the enormous speed gain resulting from COPY and maintain > your data continuity. So... (bear with me here.. trying to make sense of this).. With triggers there's a way I can do the parsing I need to on a log file and react to completed events in non-sequential order (you can ignore that part.. it's just how we piece together different related events) and then have perl/DBD::Pg invoke a copy command (which, from what I can tell, has to operate on a file...) and the copy command can feed the ID I need back to perl so I can work with it... If that doesn't hurt my brain, then I'm at least kinda confused... Anyway. Heading home now. I'll think about this more tonight/tomorrow.