Quick Links

Re: [PERFORMANCE] Stored Procedures

From:	"Jim C(dot) Nasby" <jnasby(at)pervasive(dot)com>
To:	Rikard Pavelic <rikard(dot)pavelic(at)zg(dot)htnet(dot)hr>
Cc:	pgsql-performance(at)postgresql(dot)org
Subject:	Re: [PERFORMANCE] Stored Procedures
Date:	2006-01-20 21:34:55
Message-ID:	20060120213455.GT20182@pervasive.com
Views:	Raw Message \| Whole Thread \| Download mbox \| Resend email
Thread:
Lists:	pgsql-performance

On Fri, Jan 20, 2006 at 08:38:23PM +0100, Rikard Pavelic wrote:
> This would solve problems with prepare which is per session, so for
> prepared function to be
> optimal one must use same connection.

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.
--
Jim C. Nasby, Sr. Engineering Consultant jnasby(at)pervasive(dot)com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461

In response to

Re: [PERFORMANCE] Stored Procedures at 2006-01-20 19:38:23 from Rikard Pavelic

Responses

Re: [PERFORMANCE] Stored Procedures at 2006-01-21 07:59:28 from Rikard Pavelic
Re: [PERFORMANCE] Stored Procedures at 2006-01-21 21:06:13 from Rikard Pavelic
Re: [PERFORMANCE] Stored Procedures at 2006-01-23 08:14:14 from Marcos

Browse pgsql-performance by date

	From	Date	Subject
Next Message	Martijn van Oosterhout	2006-01-20 21:37:54	Re: [GENERAL] Creation of tsearch2 index is very slow
Previous Message	Tom Lane	2006-01-20 21:19:15	Re: [GENERAL] Creation of tsearch2 index is very slow