Andy Colson <andy@xxxxxxxxxxxxxxx> writes: > Here are my results, if there are any others you'd like to see please > let me know. Thanks Tom. For comparison, could we see the results for the non-partial case, ie explain analyze select * from search where search_vec @@ to_tsquery('213 & E & 13 & ST & N'); regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general