Re: Stored Procedures - Mailing list pgsql-performance

From Andreas Kretschmer
Subject Re: Stored Procedures
Whole thread Raw
In response to Stored Procedures  ("Benjamin Arai")
List 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 by date:

From: "Benjamin Arai"
Subject: Stored Procedures
From: Vivek Khera
Subject: Re: 3WARE Card performance boost?