From jaspreet@noida.hclt.com Mon May  29 14:24:42 2000
Received: from mercury.noida.hclt.com ([204.160.248.59])
	by hub.org (8.9.3/8.9.3) with ESMTP id KAA22743
	for <pgsql-interfaces@postgresql.org>;
	Mon, 29 May 2000 10:24:42 -0400 (EDT)
	(envelope-from jaspreet@noida.hclt.com)
Received: from jaspreet (jaspreet [204.160.254.232])
	by mercury.noida.hclt.com (8.8.7/8.8.7) with SMTP id TAA08006
	for <pgsql-interfaces@postgresql.org>; Mon, 29 May 2000 19:54:24 +0530
Message-ID: <026601bfc97a$054f9d40$e8fea0cc@noida.hclt.com>
From: "Jaspreet Singh" <jaspreet@noida.hclt.com>
To: <pgsql-interfaces@postgresql.org>
Subject: Embedded Vacuum sql
Date: Mon, 29 May 2000 19:57:29 +0530
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_0263_01BFC9A8.1ECDB670"
X-Priority: 3
X-MSMail-Priority: Normal
X-Mailer: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
X-Archive-Number: 200005/83

This is a multi-part message in MIME format.

------=_NextPart_000_0263_01BFC9A8.1ECDB670
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

Hi,
I am a developing a PGE application in 6.5.3 using ecpg and libpq.
However I am unable to Vacuum Analyze the tables  using embedded sql. But t=
he same command works from the prompt through vacuumdb comand.
This I detect while query. My query takes 1 hr if vacuum hasn't been done o=
n the database.=20
I use the following command :-
"EXEC SQL VACUUM ANALYZE <Table Name>
Kindly let me know how to use embedded sql to vacuum analyze.

thanx and regards,
jaspreet

------=_NextPart_000_0263_01BFC9A8.1ECDB670
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<DIV><FONT face=3DArial>Hi,</FONT></DIV>
<DIV><FONT face=3DArial>I am a developing a PGE application in 6.5.3 using =
ecpg=20
and libpq.</FONT></DIV>
<DIV><FONT face=3DArial>However I am unable to Vacuum Analyze the tables&nb=
sp;=20
using embedded sql. But the same command works from the prompt through vacu=
umdb=20
comand.</FONT></DIV>
<DIV><FONT face=3DArial>This I detect while query. My query takes 1 hr if v=
acuum=20
hasn't been done on the database. </FONT></DIV>
<DIV><FONT face=3DArial>I use the following command :-</FONT></DIV>
<DIV><FONT face=3DArial>"EXEC SQL VACUUM ANALYZE &lt;Table Name&gt;</FONT><=
/DIV>
<DIV><FONT face=3DArial>Kindly let me know how to use embedded sql to vacuu=
m=20
analyze.</FONT></DIV>
<DIV>&nbsp;</DIV>
<DIV><FONT face=3DArial>thanx and regards,</FONT></DIV>
<DIV><FONT face=3DArial>jaspreet</FONT></DIV></BODY></HTML>

------=_NextPart_000_0263_01BFC9A8.1ECDB670--




From meskes@postgresql.org Tue May  30 10:32:32 2000
Received: from feivel.fam-meskes.de (pC19EBED0.dip0.t-ipconnect.de
	[193.158.190.208]) by hub.org (8.9.3/8.9.3) with ESMTP id GAA07832
	for <pgsql-interfaces@postgresql.org>;
	Tue, 30 May 2000 06:32:32 -0400 (EDT)
	(envelope-from michael@fam-meskes.de)
Received: by feivel.fam-meskes.de (Postfix, from userid 1000)
	id E2DF22BD30; Tue, 30 May 2000 10:23:37 +0200 (CEST)
Date: Tue, 30 May 2000 10:23:37 +0200
From: Michael Meskes <meskes@postgresql.org>
To: Jaspreet Singh <jaspreet@noida.hclt.com>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: Embedded Vacuum sql
Message-ID: <20000530102337.A2904@fam-meskes.de>
Mail-Followup-To: Jaspreet Singh <jaspreet@noida.hclt.com>,
	pgsql-interfaces@postgresql.org
References: <026601bfc97a$054f9d40$e8fea0cc@noida.hclt.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Disposition: inline
User-Agent: Mutt/1.1.9i
In-Reply-To: <026601bfc97a$054f9d40$e8fea0cc@noida.hclt.com>;
	from jaspreet@noida.hclt.com on Mon, May 29, 2000 at 07:57:29PM
	+0530
X-Archive-Number: 200005/95

On Mon, May 29, 2000 at 07:57:29PM +0530, Jaspreet Singh wrote:
> I am a developing a PGE application in 6.5.3 using ecpg and libpq. However
> I am unable to Vacuum Analyze the tables using embedded sql. But the same
> command works from the prompt through vacuumdb comand. This I detect while

What exactly doesn't work with embedded sql? I only tried calling vacuum
without analyse. And that worked.

> query. My query takes 1 hr if vacuum hasn't been done on the database.  I
> use the following command :- "EXEC SQL VACUUM ANALYZE <Table Name> Kindly

Does ECPG bark on this command? Or is it incorrectly executed? What happens?

Michael
-- 
Michael Meskes
Michael@Fam-Meskes.De
Go SF 49ers! Go Rhein Fire!
Use Debian GNU/Linux! Use PostgreSQL!