From: Michael Meskes <meskes@postgresql.org>
To: Jaspreet Singh <jaspreet@noida.hclt.com>
Cc: pgsql-interfaces@postgresql.org
Subject: Re: Embedded Vacuum sql
Date: Tue, 30 May 2000 10:23:37 +0200
Message-ID: <20000530102337.A2904@fam-meskes.de> (raw)
In-Reply-To: <026601bfc97a$054f9d40$e8fea0cc@noida.hclt.com>
References: <026601bfc97a$054f9d40$e8fea0cc@noida.hclt.com>
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!
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: meskes@postgresql.org, jaspreet@noida.hclt.com
Subject: Re: Embedded Vacuum sql
In-Reply-To: <20000530102337.A2904@fam-meskes.de>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox