From: | "Brett W(dot) McCoy" <bmccoy(at)chapelperilous(dot)net> |
---|---|
To: | Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: full-text indexing |
Date: | 2000-04-19 03:45:12 |
Message-ID: | Pine.LNX.4.10.10004182343360.9087-100000@chapelperilous.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
On Tue, 18 Apr 2000, Bruce Momjian wrote:
> Let me be specific. The problem is that without cluster, your fragment
> rows are together in the index, but are all over the heap table, so you
> have to read in all those disk buffers, and that is slow. With cluster,
> most of your matching fragments are on the same disk page, so one access
> gets them all.
>
> The nightly CLUSTER is a pain, but the only way I ever got it working
> quickly.
This is pretty painless compared to what I've had to do getting big
full-text systems like Excalibur to work. I can deal with a nightly
cluster.
Brett W. McCoy
http://www.chapelperilous.net
---------------------------------------------------------------------------
Twenty two thousand days.
Twenty two thousand days.
It's not a lot.
It's all you've got.
Twenty two thousand days.
-- Moody Blues, "Twenty Two Thousand Days"
From | Date | Subject | |
---|---|---|---|
Next Message | Alex Pilosov | 2000-04-19 04:08:04 | Re: Connecting website with SQL-database..... |
Previous Message | Brett W. McCoy | 2000-04-19 03:21:31 | Re: full-text indexing |