From owner-freebsd-questions@FreeBSD.ORG  Tue Oct  2 05:57:00 2007
Return-Path: <owner-freebsd-questions@FreeBSD.ORG>
Delivered-To: freebsd-questions@FreeBSD.ORG
Received: from mx1.freebsd.org (mx1.freebsd.org [IPv6:2001:4f8:fff6::34])
	by hub.freebsd.org (Postfix) with ESMTP id C69EF16A41B
	for <freebsd-questions@FreeBSD.ORG>;
	Tue,  2 Oct 2007 05:57:00 +0000 (UTC)
	(envelope-from philippe.lang@attiksystem.ch)
Received: from mail.attiksystem.ch (f29.attiksystem.ch [212.147.59.29])
	by mx1.freebsd.org (Postfix) with ESMTP id 23FB213C45D
	for <freebsd-questions@FreeBSD.ORG>;
	Tue,  2 Oct 2007 05:56:59 +0000 (UTC)
	(envelope-from philippe.lang@attiksystem.ch)
Received: from poweredge.attiksystem.ch (poweredge.attiksystem.ch [10.0.0.29])
	by mail.attiksystem.ch (8.12.11/8.12.11) with ESMTP id l925dkN2099700
	for <freebsd-questions@FreeBSD.ORG>;
	Tue, 2 Oct 2007 07:39:46 +0200 (CEST)
	(envelope-from philippe.lang@attiksystem.ch)
Content-Class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="us-ascii"
Content-Transfer-Encoding: quoted-printable
X-MimeOLE: Produced By Microsoft Exchange V6.0.6619.12
Date: Tue, 2 Oct 2007 07:39:46 +0200
Message-ID: <6C0CF58A187DA5479245E0830AF84F42337D2B@poweredge.attiksystem.ch>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: Execution plan caching
thread-index: AcgEtqnA6XFIfUMjSMqEA73EdEmpEQ==
From: "Philippe Lang" <philippe.lang@attiksystem.ch>
To: <freebsd-questions@FreeBSD.ORG>
X-Spam-Score: -1.44 () ALL_TRUSTED
X-Scanned-By: MIMEDefang 2.49 on 10.0.0.111
Cc: 
Subject: Execution plan caching
X-BeenThere: freebsd-questions@freebsd.org
X-Mailman-Version: 2.1.5
Precedence: list
List-Id: User questions <freebsd-questions.freebsd.org>
List-Unsubscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=unsubscribe>
List-Archive: <http://lists.freebsd.org/pipermail/freebsd-questions>
List-Post: <mailto:freebsd-questions@freebsd.org>
List-Help: <mailto:freebsd-questions-request@freebsd.org?subject=help>
List-Subscribe: <http://lists.freebsd.org/mailman/listinfo/freebsd-questions>, 
	<mailto:freebsd-questions-request@freebsd.org?subject=subscribe>
X-List-Received-Date: Tue, 02 Oct 2007 05:57:00 -0000

Hi,

I have recently used the MS SQL Server 2005 database, and found out that
there is no mecanism where an execution plan can be reused between two
successive calls to a view. This is only true with stored procedures.

Is that also true with the Postgresql engine?

Philippe