From: | Hannes Dorbath <light(at)theendofthetunnel(dot)de> |
---|---|
To: | Oleg Bartunov <oleg(at)sai(dot)msu(dot)su> |
Subject: | Re: TSearch: CLUSTER using GIST, query using GIN? |
Date: | 2008-01-19 15:21:34 |
Message-ID: | 4792157E.5050101@theendofthetunnel.de |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Oleg Bartunov wrote:
> what do you want to speed up ? Search is very fast, see explain analyze.
> The problem usually in the access to documents found to calculate
> rank, headlines. If GIN returns N documents, then you need to read
> all of them to calculate rank and here you get slowdown.
I don't use headline or rank yet. It's a pure test setup. The table is
around 130GB in size. The disc sub system is able to deliver around
430MB/sec sequential read, but it dies in random seek activity. To my
understanding this because of MVCC checking the visibility of each
matching row. Now I though I could improve that by moving similar rows
physically closer together. It's static data, it won't change at all.
--
Best regards,
Hannes Dorbath
From | Date | Subject | |
---|---|---|---|
Next Message | Pavel Stehule | 2008-01-19 15:30:49 | Re: turning off notices |
Previous Message | Sue Fitt | 2008-01-19 15:10:33 | turning off notices |