Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-performance by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group