Wade, how many distinct patterns do you have in that table? What's the population distribution (in particular, do the top 32 patterns account for most of the table)?
It's looking like the issue is not so much that the 7.3 code is completely broken, as that its LRU replacement policy for precompiled regex patterns got rejiggered in a way that doesn't match your data. regards, tom lane ---------------------------(end of broadcast)--------------------------- TIP 3: if posting/reading through Usenet, please send an appropriate subscribe-nomail command to [EMAIL PROTECTED] so that your message can get through to the mailing list cleanly