Ivan Sergio Borgonovo <[EMAIL PROTECTED]> writes:
> Tom Lane <[EMAIL PROTECTED]> wrote:
>> Can you put together a self-contained test case that illustrates
>> this?
> I'm trying... Tonight I just let my long transaction run all night.
> It has been running for about 10h and it blocked on index
> r
On Wed, 05 Nov 2008 10:53:38 -0500
Tom Lane <[EMAIL PROTECTED]> wrote:
> Ivan Sergio Borgonovo <[EMAIL PROTECTED]> writes:
> > Tom Lane <[EMAIL PROTECTED]> wrote:
> >> Can you put together a self-contained test case that illustrates
> >> this?
>
> > I'm trying... Tonight I just let my long transa
On Tue, 04 Nov 2008 10:33:26 -0500
Tom Lane <[EMAIL PROTECTED]> wrote:
> Ivan Sergio Borgonovo <[EMAIL PROTECTED]> writes:
> > It seems that gin creation is triggering something nasty in the
> > server that depends on previous history of the server.
>
> Can you put together a self-contained test
Ivan Sergio Borgonovo <[EMAIL PROTECTED]> writes:
> It seems that gin creation is triggering something nasty in the
> server that depends on previous history of the server.
Can you put together a self-contained test case that illustrates this?
regards, tom lane
--
Sent v
It seems that gin creation is triggering something nasty in the
server that depends on previous history of the server.
If I vacuum full than drop the index and recreate it even with
maintenance_work_mem='200MB' index creation may take forever.
Stopping the execution may make vacuuming very slow or
