On Wed, Jul 7, 2010 at 9:31 AM, Michal Fapso <michal.fa...@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 -- Sent via pgsql-performance mailing list (pgsql-performance@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance