Re: still gin index creation takes forever

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Teodor Sigaev <teodor(at)sigaev(dot)ru>
Cc: Ivan Sergio Borgonovo <mail(at)webthatworks(dot)it>, pgsql-general(at)postgresql(dot)org
Subject: Re: still gin index creation takes forever
Date: 2008-11-12 14:47:47
Message-ID: 14167.1226501267@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Teodor Sigaev <teodor(at)sigaev(dot)ru> writes:
> GIN's build algorithm could use bulk insert of ItemPointers if and only if they
> should be inserted on rightmost page (exact piece of code - dataPlaceToPage() in
> gindatapage.c, lines 407-427)

I'm not following. Rightmost page of what --- it can't be the whole
index, can it, or the case would hardly ever apply?

> Is any way to force table's scan from the beginning?

We could extend IndexBuildHeapScan's API to support that, but I'm
not quite convinced that this is the issue.

regards, tom lane

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Grzegorz Jaśkiewicz 2008-11-12 14:51:34 Re: sort_mem param of postgresql.conf
Previous Message Scott Marlowe 2008-11-12 14:45:40 Re: sort_mem param of postgresql.conf