From: | Alvaro Herrera Munoz <alvherre(at)dcc(dot)uchile(dot)cl> |
---|---|
To: | Carmen Gloria Sepulveda Dedes <csepulveda(at)atichile(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Execute vacuum |
Date: | 2003-11-21 21:08:37 |
Message-ID: | 20031121210837.GA22596@dcc.uchile.cl |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Fri, Nov 21, 2003 at 05:53:50PM -0300, Carmen Gloria Sepulveda Dedes wrote:
> > I think you need to enable or disable autocommit somehow.
> > Or if ECPG has some function to execute the vacuum without begin/commit.
> > I'm not familiar with ECPG, so i don't have any other ideas...
>
> I set autocommit to on and off, but did not work.
I think Michael said last week you could use ecpg -t to use VACUUM
with ecpg. Not sure what other effects it has though.
--
Alvaro Herrera (<alvherre[(at)]dcc(dot)uchile(dot)cl>)
"Uno combate cuando es necesario... no cuando est de humor!
El humor es para el ganado, o para hacer el amor, o para tocar el
baliset. No para combatir." (Gurney Halleck)
From | Date | Subject | |
---|---|---|---|
Next Message | Alvaro Herrera Munoz | 2003-11-21 21:12:04 | Re: Where is Postgesql ? - MYSQL SURPRISES WITH MAXDB / |
Previous Message | Bruno Wolff III | 2003-11-21 21:04:45 | Re: Foreign Keys |