Re: Tsearch2 performance on big database

From: Rick Jansen
Subject: Re: Tsearch2 performance on big database
Date: ,
Msg-id: 42429D3C.9000509@rockingstone.nl
(view: Whole thread, Raw)
In response to: Re: Tsearch2 performance on big database  (Oleg Bartunov)
List: pgsql-performance

Tree view

Tsearch2 performance on big database  (Rick Jansen, )
 Re: Tsearch2 performance on big database  (Oleg Bartunov, )
  Re: Tsearch2 performance on big database  (Mike Rylander, )
   Re: Tsearch2 performance on big database  (Oleg Bartunov, )
   Re: Tsearch2 performance on big database  (Rick Jansen, )
    Re: Tsearch2 performance on big database  (Mike Rylander, )
     Re: Tsearch2 performance on big database  (Oleg Bartunov, )
      Re: Tsearch2 performance on big database  (Rick Jansen, )
       Re: Tsearch2 performance on big database  (Oleg Bartunov, )
        Re: Tsearch2 performance on big database  (Rick Jansen, )
         Re: Tsearch2 performance on big database  (Oleg Bartunov, )
          Re: Tsearch2 performance on big database  (Rick Jansen, )
           Re: Tsearch2 performance on big database  (Oleg Bartunov, )
            Re: Tsearch2 performance on big database  (Rick Jansen, )

Oleg Bartunov wrote:
>
> stat() is indeed a bigdog, it was designed for developers needs,
> so we recommend to save results in table.
>
>>
>> Anyway, here's my pg_ts_cfgmap now (well the relevant bits):
>>
>> default_english | lhword       | {en_ispell,en_stem}
>> default_english | lpart_hword  | {en_ispell,en_stem}
>> default_english | lword        | {en_ispell,en_stem}
>>
>> Is it normal that queries for single words (or perhaps they are words
>> that are common) take a really long time? Like this:
>>
>
> 'hispanic' isn't common, I see you get only  674 rows and 'buckingham &
> palace'  returns 185 rows. Did you run 'vacuum analyze' ?
> I see a big discrepancy between estimated rows (8041) and actual rows.
>
>

Yes, I did a vacuum analyze right before executing these queries.

I'm going to recreate the gist index now, and do a vacuum full analyze
after that.. see if that makes a difference.

Rick

--
Systems Administrator for Rockingstone IT
http://www.rockingstone.com
http://www.megabooksearch.com - Search many book listing sites at once


pgsql-performance by date:

From: Stephan Szabo
Date:
Subject: Re: clear function cache (WAS: SQL function inlining)
From: "Otto Blomqvist"
Date:
Subject: pg_autovacuum not having enough suction ?