[GENERAL] [OT] newsreader issue? (Was: bytea encode performance issues)
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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] [OT] newsreader issue? (Was: bytea encode performance issues)
The [EMAIL PROTECTED] 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 [EMAIL PROTECTED] 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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] [OT] newsreader issue? (Was: bytea encode performance issues)
On 04/08/2008, Lew [EMAIL PROTECTED] wrote: 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)? He was quoting Alban Hertroys, and it appeared on the general mailing list (I didn't even know there was a Newsgroup). There seems to be a problem with your mail address, however ... ;} -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] [OT] newsreader issue? (Was: bytea encode performance issues)
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 [EMAIL PROTECTED] wrote: The [EMAIL PROTECTED] 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 [EMAIL PROTECTED] 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@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] [OT] newsreader issue? (Was: bytea encode performance issues)
On Sun, Aug 3, 2008 at 8:01 PM, Andrej Ricnik-Bay [EMAIL PROTECTED] wrote: On 04/08/2008, Lew [EMAIL PROTECTED] wrote: 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)? He was quoting Alban Hertroys, and it appeared on the general mailing list (I didn't even know there was a Newsgroup). Wow! So, maybe everybody did need to see then. Still... There seems to be a problem with your mail address, however ... ;} -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] [OT] newsreader issue? (Was: bytea encode performance issues)
On 04/08/2008, Scott Marlowe [EMAIL PROTECTED] wrote: 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? Aye ... dodgy spam-protection methods like that really suck. -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
Re: [GENERAL] [OT] newsreader issue? (Was: bytea encode performance issues)
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 I got the response by email, but it was also addressed to the mailing list. My response was also an email sent to the mailing list, not to the newsgroup. I got one other response, that I do not see in the newsgroup. And I will reply to it also using the mailing list. Sim 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)? -BEGIN PGP SIGNATURE- Version: GnuPG v1.4.9 (MingW32) Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org iEYEARECAAYFAkiWk20ACgkQjDX6szCBa+pwzwCffdE3KZAg0f2TjUiq+gFCOrML HM4An2wcV9G9aAE+94DH6Vwc6deMIHB4 =N0v/ -END PGP SIGNATURE- -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general