On Wed, Jul 7, 2010 at 9:31 AM, Michal Fapso <[email protected]> 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 ([email protected]) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-performance
