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
Message-ID: <026601bfc97a$054f9d40$e8fea0cc@noida.hclt.com> (raw)
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 the 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 on the database.
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
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: jaspreet@noida.hclt.com
Subject: Re: Embedded Vacuum sql
In-Reply-To: <026601bfc97a$054f9d40$e8fea0cc@noida.hclt.com>
* 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