pg.ddx.io pgsql-interfaces@postgresql.org mailing list archivehelp / color / mirror / Atom feed
Embedded Vacuum sql 2+ messages / 2 participants [nested] [flat]
* Embedded Vacuum sql @ 2000-05-29 14:27 Jaspreet Singh <jaspreet@noida.hclt.com> 2000-05-30 08:23 ` Re: Embedded Vacuum sql Michael Meskes <meskes@postgresql.org> 0 siblings, 1 reply; 2+ messages in thread From: Jaspreet Singh @ 2000-05-29 14:27 UTC (permalink / raw) To: pgsql-interfaces 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 ^ permalink raw reply [nested|flat] 2+ messages in thread
* Re: Embedded Vacuum sql 2000-05-29 14:27 Embedded Vacuum sql Jaspreet Singh <jaspreet@noida.hclt.com> @ 2000-05-30 08:23 ` Michael Meskes <meskes@postgresql.org> 0 siblings, 0 replies; 2+ messages in thread From: Michael Meskes @ 2000-05-30 08:23 UTC (permalink / raw) To: Jaspreet Singh <jaspreet@noida.hclt.com>; +Cc: pgsql-interfaces 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! ^ permalink raw reply [nested|flat] 2+ messages in thread
end of thread, other threads:[~2000-05-30 08:23 UTC | newest] Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed) -- links below jump to the message on this page -- 2000-05-29 14:27 Embedded Vacuum sql Jaspreet Singh <jaspreet@noida.hclt.com> 2000-05-30 08:23 ` Michael Meskes <meskes@postgresql.org>
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