Re: [OT] newsreader issue? (Was: bytea encode performance issues)
От | Sim Zacks |
---|---|
Тема | Re: [OT] newsreader issue? (Was: bytea encode performance issues) |
Дата | |
Msg-id | g7641i$19aj$1@news.hub.org обсуждение исходный текст |
Ответ на | [OT] newsreader issue? (Was: bytea encode performance issues) (Lew <com.lewscanon@lew>) |
Список | pgsql-general |
-----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-----
В списке pgsql-general по дате отправления: