Postgres Pro
Downloads
Home   >   mailing lists

Re: big data - slow select (speech search) - Mailing list pgsql-performance

From Robert Haas
Subject Re: big data - slow select (speech search)
Date
Msg-id AANLkTil4mgQ1pGPBV4UyXdfZoQt-YRttg7jXhurdenWG@mail.gmail.com
Whole thread Raw
In response to Re: big data - slow select (speech search)  (Michal Fapso <michal.fapso@gmail.com>)
List pgsql-performance
Tree view 
On Wed, Jul 7, 2010 at 9:31 AM, Michal Fapso <michal.fapso@gmail.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

pgsql-performance by date:

Previous
From: Kenneth Marshall
Date:
Subject: Re: Highly Efficient Custom Sorting
Next
From: Jerry Gamache
Date:
Subject: Logarithmic data frequency distributions and the query planner