One last thing. I'd rather my emails just get dropped silently if that's the minimum someone can do. Use a valid email address that goes to /dev/null and I'll be happy. You may miss a few things sent directly to you, but since that's not what you want anyway, it's no big loss, right? On Sun, Aug 3, 2008 at 7:59 PM, Scott Marlowe <scott.marlowe@xxxxxxxxx> wrote: > The com.lewscanon@lew email address is invalid. I tried to send it this email: > > If I remember correctly, the news feed is gatewayed off the mailing > list, so it's possible for a message to the list to not appear in the > group if it gets dropped at the gateway. Sorry if this is redundant > info for you. > > If you don't wish to receive spam on your regular email address > (understandable) then either switch to reading and posting with a > gmail account (got lots of invites, just ask) or set up a separate > account to receive emails from pgsql and set up spam assassin and (/ > or) a couple of whitelists and use that. It's kinda rude to ask me a > question on a mailing list with an email address I can't respond to. > I spend time writing up an answer that only you needed to see, and > then can't send it to YOU, but only the whole list. > > On Sun, Aug 3, 2008 at 8:03 AM, Lew <com.lewscanon@lew> wrote: >> Sim Zacks wrote: >>> >>> (quoting someone:) >>>> >>>> That LIKE operator is probably your problem. An unbounded LIKE like that >>>> (with a wildcard on both sides) means no index can be used, hence you >>>> get a sequential scan. >> >> Was the message to which you responded posted to the newsgroup? It isn't >> appearing in my newsreader. >> >> Who wrote the message you quoted (you failed to cite the source)? >> >> -- >> Lew >> >> -- >> Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) >> To make changes to your subscription: >> http://www.postgresql.org/mailpref/pgsql-general >> >