Re: bind variables, soft vs hard parse

From: Marcus Engene <mengpg(at)engene(dot)se>
To: "Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: bind variables, soft vs hard parse
Date: 2005-11-21 20:14:33
Message-ID: 43822AA9.1000900@engene.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Jim C. Nasby wrote:
> It might be more useful to look at caching only planning and not
> parsing. I'm not familiar with the output of the parsing stage, but
> perhaps that could be hashed to use as a lookup into a cache of planned
> queries. I suspect that would remove issues of different search_paths.

A really stupid question, in the cached query-string, wouldn't it be
possible to add the env specifics? Ie the string to check against is
something like

search_paths=...\n
SELECT ...

Or would there be too much stuff to append/prepend?

Best regards,
Marcus

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Bob Ippolito 2005-11-21 20:38:00 Re: PostgreSQL 8.1.0 catalog corruption
Previous Message Bruce Momjian 2005-11-21 19:53:34 Re: Time for pgindent?