Re: Roadmap for FE/BE protocol redesign

> -----Original Message-----
> From: Hiroshi Inoue [mailto:Inoue(at)tpf(dot)co(dot)jp]
> Sent: 13 March 2003 10:04
> To: Dave Page
> Cc: tgl(at)sss(dot)pgh(dot)pa(dot)us; ZeugswetterA(at)spardat(dot)at;
> pgman(at)candle(dot)pha(dot)pa(dot)us; pgsql-hackers(at)postgresql(dot)org;
> pgsql-interfaces(at)postgresql(dot)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. This is useful for additional info
such as uniqueness, nullability, default value, contraints and so on.
Surely you don't want to get the entire relevant bits of the system
catalogues with every query unless we specifically request it?

Regards, Dave.