Postgres Pro
Downloads
Home   >   mailing lists

Thread: Embedded Vacuum sql

Embedded Vacuum sql

From
"Jaspreet Singh"
Date:
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

Re: Embedded Vacuum sql

From
Michael Meskes
Date:
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!