Skip site navigation (1) Skip section navigation (2)

Re: AW: Re: [GENERAL] Query caching

From: Christof Petig <christof(dot)petig(at)wtal(dot)de>
To: Karel Zak <zakkr(at)zf(dot)jcu(dot)cz>
Cc: Zeugswetter Andreas SB <ZeugswetterA(at)wien(dot)spardat(dot)at>, The Hermit Hacker <scrappy(at)hub(dot)org>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: AW: Re: [GENERAL] Query caching
Date: 2000-11-03 15:47:11
Message-ID: 3A02DDFF.E8CBFCF3@wtal.de (view raw or flat)
Thread:
Lists: pgsql-hackers
Karel Zak wrote:

> On Thu, 2 Nov 2000, Zeugswetter Andreas SB wrote:
>
> >
> > > Well I can re-write and resubmit this patch. Add it as a
> > > compile time option
> > > is not bad idea. Second possibility is distribute it as patch
> > > in the contrib
> > > tree. And if it until not good tested not dirty with this main tree...
> > >
> > >  Ok, I next week prepare it...
> >
> > One thing that worries me though is, that it extends the sql language,
> > and there has been no discussion about the chosen syntax.
> >
> > Imho the standard embedded SQL syntax (prepare ...) could be a
> > starting point.
>
>  Yes, you are right... my PREPARE/EXECUTE is not too much ready to SQL92,
> I some old letter I speculate about "SAVE/EXECUTE PLAN" instead
> PREPARE/EXECUTE. But don't forget, it will *experimental* patch... we can
> change it in future ..etc.
>
>                                         Karel

[Sorry, I didn't look into your patch, yet.]
What about parameters? Normally you can prepare a statement and execute it
using different parameters. AFAIK postgres' frontend-backend protocol is not
designed to take parameters for statements (e.g. like result presents
results). A very long road to go.
By the way, I'm somewhat interested in getting this feature in. Perhaps it
should be part of a protocol redesign (e.g. binary parameters/results).
Handling endianness is one aspect, floats are harder (but float->ascii->float
sometimes fails as well).

Christof



In response to

Responses

pgsql-hackers by date

Next:From: Tom LaneDate: 2000-11-03 16:08:49
Subject: Re: [HACKERS] OSDN Database conference report (long)
Previous:From: Ross J. ReedstromDate: 2000-11-03 15:29:07
Subject: Re: Re: [COMMITTERS] pgsql/contrib/pg_dumpaccounts (Makefile README pg_dumpaccounts.sh)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group