>>>>> "Paul" == Paul J Stevens <[EMAIL PROTECTED]> writes:
Paul> Nothing? In mysql you can do a index on the first x characters of a Paul> field. I'm sure something similar is possible in pgsql, but I haven't Paul> had time to figure it out yet. For now, just comment the line involved. The error message I got from pg suggests doing: CREATE INDEX dbmail_headervalue_3 ON MD5(dbmail_headervalue(headervalue)); and using MD5() in the query. In many of the cases, though, I suspect the indices should be on lower(whatever) and lower() should be in the queries. OTOH, since the use of ILIKE and/or ~ invalidates the need for indices, they currenly are providing almost no value, just making INSERTs and UPDATEs more expensive. Only when = is used whenever possible will the indices provide any real value. -JimC -- James Cloos <[EMAIL PROTECTED]> OpenPGP: 1024D/ED7DAEA6 _______________________________________________ DBmail mailing list [email protected] https://mailman.fastxs.nl/mailman/listinfo/dbmail
