From: Benjamin Arai <me@benjaminarai.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: Oleg Bartunov <oleg@sai.msu.su>
Cc: PostgreSQL <pgsql-general@postgresql.org>
Cc: pgsql-performance@postgresql.org
Subject: Re: [PERFORM] Slow TSearch2 performance for table with 1 million documents.
Date: Thu, 11 Oct 2007 09:12:20 -0700
Message-ID: <0041AF31-D807-4775-B7CF-745B0A1706E2@benjaminarai.com> (raw)
In-Reply-To: <21653.1192117985@sss.pgh.pa.us>
References: <D582BC3F-9F49-40C9-A959-1F9C8D3AA60B@araisoft.com>
<16663.1191597165@sss.pgh.pa.us>
<Pine.LNX.4.64.0710051932030.3304@sn.sai.msu.ru>
<6936504E-3560-4BE9-86BE-BEDAB3CD355A@araisoft.com>
<3E8290A0-05DA-4F0F-A783-859124278D27@benjaminarai.com>
<21653.1192117985@sss.pgh.pa.us>
Oh, I see. I didn't look carefully at the EXPLAIN ANALYZE I posted.
So, is there a solution to the rank problem?
Benjamin
On Oct 11, 2007, at 8:53 AM, Tom Lane wrote:
> Benjamin Arai <me@benjaminarai.com> writes:
>> It appears that the ORDER BY rank operation is the slowing factor.
>> If I remove it then the query is pretty fast. Is there another way
>> to perform ORDER BY such that it does not do a sort?
>
> I think you misunderstood: it's not the sort that's slow, it's the
> computation of the rank() values that are inputs to the sort.
>
> regards, tom lane
>
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-performance@postgresql.org
Cc: me@benjaminarai.com, tgl@sss.pgh.pa.us, oleg@sai.msu.su, pgsql-general@postgresql.org
Subject: Re: [PERFORM] Slow TSearch2 performance for table with 1 million documents.
In-Reply-To: <0041AF31-D807-4775-B7CF-745B0A1706E2@benjaminarai.com>
References: <D582BC3F-9F49-40C9-A959-1F9C8D3AA60B@araisoft.com> <16663.1191597165@sss.pgh.pa.us> <Pine.LNX.4.64.0710051932030.3304@sn.sai.msu.ru> <6936504E-3560-4BE9-86BE-BEDAB3CD355A@araisoft.com> <3E8290A0-05DA-4F0F-A783-859124278D27@benjaminarai.com> <21653.1192117985@sss.pgh.pa.us> <0041AF31-D807-4775-B7CF-745B0A1706E2@benjaminarai.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox