Re: Patch to fix search_path defencies with pg_bench

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: Patch to fix search_path defencies with pg_bench
Дата
Msg-id 7736.1241741468@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: Patch to fix search_path defencies with pg_bench  (Greg Smith <gsmith@gregsmith.com>)
Ответы Re: Patch to fix search_path defencies with pg_bench  (Greg Smith <gsmith@gregsmith.com>)
Список pgsql-hackers
Greg Smith <gsmith@gregsmith.com> writes:
> On Thu, 7 May 2009, Aidan Van Dyk wrote:
> You are correct here.  Right now, pgbench is guaranteed to be running 
> against a search_path with only one entry in it.  If someone runs the new 
> version against a configuration with something like:

> search_path='a,b,c,d,e,f,g,h,i,j,public'

> instead, that is going to execute more slowly than the current pgbench 
> would have.

No, it is not.  The tables will be created and used in schema 'a',
and the effective search path depth will be the same.
        regards, tom lane


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

Предыдущее
От: Greg Smith
Дата:
Сообщение: Re: Patch to fix search_path defencies with pg_bench
Следующее
От: Josh Berkus
Дата:
Сообщение: [Fwd: congratulations on 8.4 beta]