| From: | Michael Meskes <meskes(at)postgresql(dot)org> |
|---|---|
| To: | Jaspreet Singh <jaspreet(at)noida(dot)hclt(dot)com> |
| Cc: | pgsql-interfaces(at)postgresql(dot)org |
| Subject: | Re: Embedded Vacuum sql |
| Date: | 2000-05-30 08:23:37 |
| Message-ID: | 20000530102337.A2904@fam-meskes.de |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | 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(at)Fam-Meskes(dot)De
Go SF 49ers! Go Rhein Fire!
Use Debian GNU/Linux! Use PostgreSQL!
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Mount | 2000-05-30 08:57:01 | RE: jdbc driver: Why it isn't jdbcCompliant? |
| Previous Message | Peter Mount | 2000-05-30 07:24:10 | RE: jdbc driver: Why it isn't jdbcCompliant? |