Well, that's not completely trivial => the plan might depend upon the
concrete value of $1,$2 and $3.
When you use PREPARE, it doesn't. I could live with that.
The purpose of this would be to have a library of "persistent prepared
statements" (just like lightweight functions) for y
"PFC" <[EMAIL PROTECTED]> writes:
> Suppose a web application with persistent database connections.
> I have some queries which take longer to plan than to execute !
There have periodically been discussions about a shared plan cache but
generally the feeling is that it would do more h
Well, that's not completely trivial => the plan might depend upon the concrete
value of $1,$2 and $3.
Andreas
-- Ursprüngl. Mitteil. --
Betreff:[PERFORM] PREPARE and stuff
Von:PFC <[EMAIL PROTECTED]>
Datum: 23.06.2007 21:31
Suppose a web application with persistent
PFC wrote:
Suppose a web application with persistent database connections.
I have some queries which take longer to plan than to execute !
I with there was a way to issue a PREPARE (like "PERSISTENT PREPARE").
Now all Postgres connections would know that prepared statement foo(
Suppose a web application with persistent database connections.
I have some queries which take longer to plan than to execute !
I with there was a way to issue a PREPARE (like "PERSISTENT PREPARE").
Now all Postgres connections would know that prepared statement foo( $1,
On Fri, 22 Jun 2007, Sabin Coanda wrote:
Instead of (or in addition to) configure dozens of settings, what do you
say about a feedback adjustable control based on the existing system
statistics and parsing logs
Take a look at the archive of this list for the end of April/Early May.
There's a
On Fri, 22 Jun 2007, Adam Tauno Williams wrote:
Just as an aside; how come the installation/setup "Tutorial" section -
http://www.postgresql.org/docs/8.2/interactive/tutorial-start.html -
doesn't mention setting some rough reasonable defaults in
postgresql.conf or even a reference to the paramet
On Thu, 21 Jun 2007, Campbell, Lance wrote:
I have a PostgreSQL database that runs on a dedicated server. The
server has 24Gig of memory. What would be the max size I would ever
want to set the shared_buffers to if I where to relying on the OS for
disk caching approach? It seems that no matte