Re: Very bad FTS performance with the Polish config

From: Euler Taveira de Oliveira <euler(at)timbira(dot)com>
To: Wojciech Knapik <webmaster(at)wolniartysci(dot)pl>
Cc: pgsql-hackers(at)postgresql(dot)org
Subject: Re: Very bad FTS performance with the Polish config
Date: 2009-11-18 01:33:59
Message-ID: 4B034F07.9050109@timbira.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Wojciech Knapik escreveu:
>
> Euler Taveira de Oliveira wrote:
>
>>> PS. This issue is not related to the loading time of dictionaries, or
>>> calls to ts_headline for results that won't be displayed.
>>
>> So what? Could you post the profiling of that query?
>
I was talking about gprof (--enable-profiling), oprofile [1] or similar tools.
But it seems the slow step is the sort one.

[1] http://wiki.postgresql.org/wiki/Profiling_with_OProfile

--
Euler Taveira de Oliveira
http://www.timbira.com/

In response to

Browse pgsql-hackers by date

  From Date Subject
Next Message Joshua Tolley 2009-11-18 02:11:00 Re: plperl and inline functions -- first draft
Previous Message Robert Haas 2009-11-18 01:15:29 Re: RFC for adding typmods to functions