X-Original-To: pgsql-hackers@postgresql.org Received: from salem.vale-housing.co.uk (mailgate.vale-housing.co.uk [193.195.77.162]) by postgresql.org (Postfix) with ESMTP id 67C00475921; Fri, 14 Mar 2003 02:45:31 -0500 (EST) thread-index: AcLp/bBt3XJgKr3tQMeRzo3ZNcfLOw== Received: from vale-housing.co.uk ([192.168.1.89] RDNS failed) by salem.vale-housing.co.uk with Microsoft SMTPSVC(5.0.2195.5329); Fri, 14 Mar 2003 07:45:31 +0000 Received: from tartanic.demon.co.uk ([80.177.99.193]) (SquirrelMail authenticated user dpage) by ssl.vale-housing.co.uk with HTTP; Fri, 14 Mar 2003 08:47:03 -0000 (GMT) Message-ID: <50177.80.177.99.193.1047631623.squirrel@ssl.vale-housing.co.uk> Content-Class: urn:content-classes:message X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4920.2300 Date: Fri, 14 Mar 2003 08:47:03 -0000 (GMT) Subject: Re: Roadmap for FE/BE protocol redesign From: "Dave Page" To: In-Reply-To: <002f01c2e9aa$02e13160$0e283ddb@PbgX> References: <03AF4E498C591348A42FC93DEA9661B8259DA3@mail.vale-housing.co.uk> <002f01c2e9aa$02e13160$0e283ddb@PbgX> X-Priority: 3 Importance: Normal X-MSMail-Priority: Normal Cc: , , , , , X-Mailer: SquirrelMail (version 1.2.6) MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit X-OriginalArrivalTime: 14 Mar 2003 07:45:31.0546 (UTC) FILETIME=[B068EFA0:01C2E9FD] X-Archive-Number: 200303/603 X-Sequence-Number: 36849 It's rumoured that Hiroshi Inoue once said: >> -----Original Message----- >> From: Dave Page >> >> > -----Original Message----- >> > From: Hiroshi Inoue [mailto:Inoue@tpf.co.jp] >> > Sent: 13 March 2003 10:04 >> > To: Dave Page >> > Cc: tgl@sss.pgh.pa.us; ZeugswetterA@spardat.at; >> > pgman@candle.pha.pa.us; pgsql-hackers@postgresql.org; >> > pgsql-interfaces@postgresql.org >> > Subject: Re: [HACKERS] Roadmap for FE/BE protocol redesign >> > >> > >> > Dave Page wrote: >> > > >> > > It's rumoured that Hiroshi Inoue once said: >> > > > >> > > > Does looking up by the catalog keys take no cost ? >> > > >> > > Obviously there is cost, but doing a lookup only on demand, >> > has got to >> > > be cheaper in the long run than including the entire column >> > definition >> > > in the message whether it's wanted or not? >> > >> > So if there are 100 fields, should we ask the backend >> > the column name 100 times ? >> >> No, the column name is there already. > > The column name isn't there. If a field has its alias name the alias is > there. Ahh yes, you're right of course. The docs are a little sketchy on that detail (http://www.postgresql.org/docs/view.php?version=7.3&idoc=1&file=protocol-message-formats.html). Regards, Dave