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