| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | Benjamin Arai <me(at)benjaminarai(dot)com> |
| Cc: | Benjamin Arai <benjamin(at)araisoft(dot)com>, Oleg Bartunov <oleg(at)sai(dot)msu(dot)su>, PostgreSQL <pgsql-general(at)postgresql(dot)org>, pgsql-performance(at)postgresql(dot)org |
| Subject: | Re: [PERFORM] Slow TSearch2 performance for table with 1 million documents. |
| Date: | 2007-10-11 15:53:05 |
| Message-ID: | 21653.1192117985@sss.pgh.pa.us |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-performance |
Benjamin Arai <me(at)benjaminarai(dot)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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Tom Lane | 2007-10-11 16:03:47 | Re: XMIN semantic at peril ? |
| Previous Message | Richard Huxton | 2007-10-11 15:50:57 | Re: Support for distributed transactions in 8.2.5 |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Benjamin Arai | 2007-10-11 16:12:20 | Re: [PERFORM] Slow TSearch2 performance for table with 1 million documents. |
| Previous Message | Benjamin Arai | 2007-10-11 14:52:29 | Re: [PERFORM] Slow TSearch2 performance for table with 1 million documents. |