Re: gin creation and previous history of server

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ivan Sergio Borgonovo <mail(at)webthatworks(dot)it>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: gin creation and previous history of server
Date: 2008-11-05 15:53:38
Message-ID: 14914.1225900418@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Ivan Sergio Borgonovo <mail(at)webthatworks(dot)it> writes:
> Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> 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
> re-creation.

I'd suggest just loading up some dummy data in a medium-size table and
seeing if you can reproduce the variance in index build time. It's
unlikely that you need a ten-hour test case for that. But there may
be some small detail of what you're doing that is necessary to show
the problem, so I'm not going to try to reproduce it here with no
concrete example to go on.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message H.J. Sanders 2008-11-05 16:04:10 xlog viewer
Previous Message Merlin Moncure 2008-11-05 15:34:00 Re: INSERT .... RETURNING