Re: [PERFORM] Performance regarding LIKE searches

2010-03-29 Thread randalls
Tom, We are using perl 5.10 with postgresql DBD. Can you point me in the right direction in terms of unamed and named prepared statements? Thanks, Randall Svancara Systems Administrator/DBA/Developer Main Bioinformatics Laboratory - Original Message - From: "Tom Lane" To: randa...@

[PERFORM] Performance regarding LIKE searches

2010-03-29 Thread randalls
Hi, I am querying a Postgresql 8.3 database table that has approximately 22 million records. The (explain analyze) query is listed below: gdr_gbrowse_live=> explain analyze SELECT f.id,f.object,f.typeid,f.seqid,f.start,f.end,f.strand FROM feature as f, name as n WHERE (n.id=f.id AND lower(n.n