Re: [OT] newsreader issue? (Was: bytea encode performance issues)

From: Sim Zacks <sim(at)compulab(dot)co(dot)il>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: [OT] newsreader issue? (Was: bytea encode performance issues)
Date: 2008-08-04 05:28:13
Message-ID: g7641i$19aj$1@news.hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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-----

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Sim Zacks 2008-08-04 06:24:33 Re: bytea encode performance issues
Previous Message Andrej Ricnik-Bay 2008-08-04 02:32:46 Re: [OT] newsreader issue? (Was: bytea encode performance issues)