Re: [PERFORMANCE] Stored Procedures

От: Rikard Pavelic
Тема: Re: [PERFORMANCE] Stored Procedures
Дата: ,
Msg-id: 43D1E9E0.3000905@zg.htnet.hr
(см: обсуждение, исходный текст)
Ответ на: Re: [PERFORMANCE] Stored Procedures  ("Jim C. Nasby")
Список: pgsql-performance

Скрыть дерево обсуждения

Re: [PERFORMANCE] Stored Procedures  (Rikard Pavelic, )
 Re: [PERFORMANCE] Stored Procedures  ("Jim C. Nasby", )
  Re: [PERFORMANCE] Stored Procedures  (Rikard Pavelic, )
   Re: [PERFORMANCE] Stored Procedures  ("Jim C. Nasby", )
    Re: [PERFORMANCE] Stored Procedures  (Rikard Pavelic, )
    Re: [PERFORMANCE] Stored Procedures  (Rikard Pavelic, )
    Re: [PERFORMANCE] Stored Procedures  (Marcos, )
     Re: [PERFORMANCE] Stored Procedures  (Markus Schaber, )
      Re: [PERFORMANCE] Stored Procedures  (Marcos, )
       Re: [PERFORMANCE] Stored Procedures  ("Dave Dutcher", )
        Re: [PERFORMANCE] Stored Procedures  (Frank Wiles, )

Jim C. Nasby wrote:
> If you're dealing with something that's performance critical you're not
> going to be constantly re-connecting anyway, so I don't see what the
> issue is.
>

I really missed your point.
In multi user environment where each user uses it's connection for
identification
purposes, this seems like a reasonable optimization.

I know there is pgpool, but it's non windows, and it's not the best
solution
for every other problem.



В списке pgsql-performance по дате сообщения:

От: K C Lau
Дата:
Сообщение: Re: SELECT MIN, MAX took longer time than SELECT
От: Martijn van Oosterhout
Дата:
Сообщение: Re: [GENERAL] Creation of tsearch2 index is very slow