Re: BUG #2594: Gin Indexes cause server to crash on Windows

From: Teodor Sigaev <teodor(at)sigaev(dot)ru>
To: Bernhard Weisshuhn <bkw(at)weisshuhn(dot)de>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2594: Gin Indexes cause server to crash on Windows
Date: 2006-08-30 10:25:37
Message-ID: 44F567A1.4090309@sigaev.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

> For the sake of completeness/reference: The backport for 8.1
> (http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/gin_tsearch2_81.gz)
> doesn't seem to have this bug, at least on a linux x86_64 machine I can
> create empty gin indexes with no problem.

It hasn't, because 8.2 already goes forward: there is a corner case when
documents has a lot of unique words (millions) and index creation time becomes
very long. 8.2 will create index much faster in this case.

>
> And the performance is sweeeet! Thanks Oleg & Teodor!

:)

--
Teodor Sigaev E-mail: teodor(at)sigaev(dot)ru
WWW: http://www.sigaev.ru/

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Filip Hrbek 2006-08-30 12:43:19 Re: Partially corrupted table
Previous Message Bernhard Weisshuhn 2006-08-30 09:59:05 Re: BUG #2594: Gin Indexes cause server to crash on Windows