Re: big data - slow select (speech search)

From: Robert Haas <robertmhaas(at)gmail(dot)com>
To: Michal Fapso <michal(dot)fapso(at)gmail(dot)com>
Cc: pgsql-performance(at)postgresql(dot)org
Subject: Re: big data - slow select (speech search)
Date: 2010-07-07 20:49:39
Message-ID: AANLkTil4mgQ1pGPBV4UyXdfZoQt-YRttg7jXhurdenWG@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-performance

On Wed, Jul 7, 2010 at 9:31 AM, Michal Fapso <michal(dot)fapso(at)gmail(dot)com> wrote:
> thank you for your help. I tried to cluster the table on
> hyps_wordid_index and the query execution time dropped from 4.43 to
> 0.19 seconds which is not that far from Lucene's performance of 0.10
> second.

Dang. Nice!

--
Robert Haas
EnterpriseDB: http://www.enterprisedb.com
The Enterprise Postgres Company

In response to

Browse pgsql-performance by date

  From Date Subject
Next Message Jerry Gamache 2010-07-07 20:54:48 Logarithmic data frequency distributions and the query planner
Previous Message Kenneth Marshall 2010-07-07 19:42:36 Re: Highly Efficient Custom Sorting