Re: [HACKERS] Index greater than 8k

On Fri, 3 Nov 2006, Joshua D. Drake wrote:

> Oleg Bartunov wrote:
>> Gregory,
>>
>> All you described you do with fti is possible with tsearch2. Just need
>> some think, of course. If you don't need stemming, just don't use it,
>> if you need something like %txt%, just write simple dictionary, which
>> produce any substrings from input word.
>
> Is there any information on writing these dictionaries?

Туториал
http://www.sai.msu.su/~megera/wiki/Gendict

Some examples are on http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/

For example,
http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/dicts/README.intdict
http://www.sai.msu.su/~megera/postgres/gist/tsearch/V2/docs/custom-dict.html

Regards,
Oleg
_____________________________________________________________
Oleg Bartunov, Research Scientist, Head of AstroNet (www.astronet.ru),
Sternberg Astronomical Institute, Moscow University, Russia
Internet: oleg(at)sai(dot)msu(dot)su, http://www.sai.msu.su/~megera/
phone: +007(495)939-16-83, +007(495)939-23-83
>From pgsql-general-owner(at)postgresql(dot)org Fri Nov 3 14:37:58 2006
Received: from localhost (mx1.hub.org [200.46.208.251])
by postgresql.org (Postfix) with ESMTP id 08A6D9FB28D
for <pgsql-general-postgresql(dot)org(at)postgresql(dot)org>; Fri, 3 Nov 2006 14:37:58 -0400 (AST)
Received: from postgresql.org ([200.46.204.71])
by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024)
with ESMTP id 27838-01-2 for <pgsql-general-postgresql(dot)org(at)postgresql(dot)org>;
Fri, 3 Nov 2006 14:37:34 -0400 (AST)
X-Greylist: delayed 00:06:40.182083 by SQLgrey-
Received: from ds528.dedicated.turbodns.co.uk (ds528.dedicated.turbodns.co.uk [81.21.72.118])
by postgresql.org (Postfix) with ESMTP id 16D569FB299
for <pgsql-general(at)postgresql(dot)org>; Fri, 3 Nov 2006 14:37:33 -0400 (AST)
Received: (qmail 32743 invoked from network); 3 Nov 2006 18:30:17 -0000
Received: from howardnews(at)selestial(dot)com by ds528.dedicated.turbodns.co.uk by uid 1005 with qmail-scanner-1.22
( Clear:RC:1(62.3.231.11):.
Processed in 0.090557 secs); 03 Nov 2006 18:30:17 -0000
Received: from unknown (HELO ?10.202.6.101?) (selestial-howard(dot)cole(at)62(dot)3(dot)231(dot)11)
by ds528.dedicated.turbodns.co.uk with SMTP; 3 Nov 2006 18:30:17 -0000
Message-ID: <454B8ADA(dot)6080604(at)selestial(dot)com>
Date: Fri, 03 Nov 2006 18:30:50 +0000
From: Howard Cole <howardnews(at)selestial(dot)com>
User-Agent: Thunderbird 1.5.0.7 (Windows/20060909)
MIME-Version: 1.0
To: 'PgSql General' <pgsql-general(at)postgresql(dot)org>
Subject: Unknown subdirectories in postgres base directory
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Archive-Number: 200611/204
X-Sequence-Number: 103300

Hi All,

I am using postgres 8.0 on a windows server and I create and delete
database frequently. However I have noticed that the number of
subdirectories in the base directory does not reflect the number of
databases.

Can I delete the directories that do not correspond to the OIDs in:

select oid, datname from pg_database;

Thanks.

Howard