Обсуждение: Embedded Vacuum sql
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
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!