"Matthew Terenzio" <mterenzio@xxxxxxxxx> writes: > There are less than 20,000 records being searched here, but the query takes > several minutes. > I know this may not be enough info, but would one suggest I optimize the > query or put my attention towards other areas. What does EXPLAIN ANALYZE show for it? regards, tom lane