Re: Parsing speed (was Re: pgstats_initstats() cost)

Поиск
Список
Период
Сортировка
От Bruce Momjian
Тема Re: Parsing speed (was Re: pgstats_initstats() cost)
Дата
Msg-id 200308170510.h7H5ANc13739@candle.pha.pa.us
обсуждение исходный текст
Ответ на Re: Parsing speed (was Re: pgstats_initstats() cost)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Is there a TODO here?  Text?

---------------------------------------------------------------------------

Tom Lane wrote:
> Christopher Kings-Lynne <chriskl@familyhealth.com.au> writes:
> > What do you actually get back from a Parse request?
> 
> Nothing.  If successful, it creates a prepared statement inside the
> server.
> 
> It might possibly make sense for a libpq routine that exposes Parse
> to actually do Parse followed by Describe Statement; that would allow
> it to give back (a) an indication of the number and types of parameters
> needed by the statement, and (b) an indication of the column set to be
> returned, if it's a SELECT.  However, the protocol doesn't tell anything
> about the type of a non-SELECT statement.  In any case, this would
> require more invention and coding than I care to do at this point in
> the release cycle (since there's no support in the guts of libpq for
> accepting ParameterDescription messages from the backend).  If that's
> what we think we want, we'd better put it on the wish-list for 7.5.
> 
>             regards, tom lane
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 9: the planner will ignore your desire to choose an index scan if your
>       joining column's datatypes do not match
> 

--  Bruce Momjian                        |  http://candle.pha.pa.us pgman@candle.pha.pa.us               |  (610)
359-1001+  If your life is a hard drive,     |  13 Roberts Road +  Christ can be your backup.        |  Newtown Square,
Pennsylvania19073
 


В списке pgsql-hackers по дате отправления:

Предыдущее
От: Joe Conway
Дата:
Сообщение: char() datatype looses strings of all spaces
Следующее
От: Tom Lane
Дата:
Сообщение: Re: Question with hashed IN