От: Andreas Kretschmer
Тема: Re: Stored Procedures
Дата: ,
Msg-id: 20060119193426.GA5403@kaufbach.delug.de
(см: обсуждение, исходный текст)
Ответ на: Stored Procedures  ("Benjamin Arai")
Список: pgsql-performance

Benjamin Arai <> schrieb:

> Hi,
> Will simple queries such as "SELECT * FROM blah_table WHERE tag='x'; work any
> faster by putting them into a stored procedure?

IMHO no, why do you think so? You can use PREPARE instead, if you have many
selects like this.

HTH, Andreas
Really, I'm not out to destroy Microsoft. That will just be a completely
unintentional side effect.                              (Linus Torvalds)
"If I was god, I would recompile penguin with --enable-fly."    (unknow)
Kaufbach, Saxony, Germany, Europe.              N 51.05082°, E 13.56889°

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

От: Bruce Momjian
Сообщение: Re: Autovacuum / full vacuum (off-topic?)
От: K C Lau
Сообщение: SELECT MIN, MAX took longer time than SELECT COUNT, MIN, MAX