Re: gin creation and previous history of server - Mailing list pgsql-general

From Tom Lane
Subject Re: gin creation and previous history of server
Date
Msg-id 14914.1225900418@sss.pgh.pa.us
Whole thread Raw
In response to Re: gin creation and previous history of server  (Ivan Sergio Borgonovo <mail@webthatworks.it>)
Responses Re: gin creation and previous history of server  (Ivan Sergio Borgonovo <mail@webthatworks.it>)
List pgsql-general
Ivan Sergio Borgonovo <mail@webthatworks.it> writes:
> Tom Lane <tgl@sss.pgh.pa.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

pgsql-general by date:

Previous
From: "Merlin Moncure"
Date:
Subject: Re: INSERT .... RETURNING
Next
From: Rafal Pietrak
Date:
Subject: Re: INSERT .... RETURNING