Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-bugs by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group