Postgres Pro
Downloads
Home   >   mailing lists

Thread: Re: [HACKERS] Roadmap for FE/BE protocol redesign

Re: [HACKERS] Roadmap for FE/BE protocol redesign

From
"Hiroshi Inoue"
Date:
> -----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.

regards,
Hiroshi Inoue

Re: [HACKERS] Roadmap for FE/BE protocol redesign

From
"Dave Page"
Date:
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