X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 8CDDF5341F for ; Thu, 24 Mar 2005 10:58:13 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 66935-08 for ; Thu, 24 Mar 2005 10:58:04 +0000 (GMT) Received: from mx1.rockingstone.nl (mx1.rockingstone.nl [82.94.241.100]) by svr1.postgresql.org (Postfix) with ESMTP id D3EA35321F for ; Thu, 24 Mar 2005 10:58:03 +0000 (GMT) Received: from localhost (web1 [127.0.0.1]) by mx1.rockingstone.nl (Postfix) with ESMTP id A0485FB0FB; Thu, 24 Mar 2005 12:04:08 +0100 (CET) Received: from mx1.rockingstone.nl ([127.0.0.1]) by localhost (web1 [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 27444-18; Thu, 24 Mar 2005 12:04:07 +0100 (CET) Received: from [10.10.20.219] (217-19-26-53.dsl.cambrium.nl [217.19.26.53]) by mx1.rockingstone.nl (Postfix) with ESMTP id A37D4FB077; Thu, 24 Mar 2005 12:04:07 +0100 (CET) Message-ID: <42429D3C.9000509@rockingstone.nl> Date: Thu, 24 Mar 2005 11:58:04 +0100 From: Rick Jansen User-Agent: Mozilla Thunderbird 1.0 (X11/20041206) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Oleg Bartunov Cc: Mike Rylander , pgsql-performance@postgresql.org Subject: Re: Tsearch2 performance on big database References: <42400F57.3040604@rockingstone.nl> <42401CBF.50403@rockingstone.nl> <42404263.40604@rockingstone.nl> <42412E4B.4010407@rockingstone.nl> <42429940.8040607@rockingstone.nl> In-Reply-To: X-Enigmail-Version: 0.90.0.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at rockingstone.nl X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0 tagged_above=0 required=5 tests= X-Spam-Level: X-Archive-Number: 200503/503 X-Sequence-Number: 11208 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