From mboxrd@z Thu Jan  1 00:00:00 1970
Return-Path: <raorn@altlinux.org>
Date: Fri, 12 Nov 2010 19:25:42 +0300
From: "Alexey I. Froloff" <raorn@altlinux.org>
To: ALT Linux Sisyphus discussion list <sisyphus@lists.altlinux.org>
Message-ID: <20101112162542.GB16999@altlinux.org>
References: <AANLkTi=kHsNE7RZKp88jVdqH4Mqe6kJRwkm02McyoeY7@mail.gmail.com>
	<20101112074704.GA16999@altlinux.org>
	<AANLkTim=dPg4LhWfr2a=-6FoANQyiq2GL3AAxyg6jEB2@mail.gmail.com>
MIME-Version: 1.0
Content-Type: multipart/signed; micalg=pgp-sha1;
	protocol="application/pgp-signature"; boundary="bCsyhTFzCvuiizWE"
Content-Disposition: inline
In-Reply-To: <AANLkTim=dPg4LhWfr2a=-6FoANQyiq2GL3AAxyg6jEB2@mail.gmail.com>
User-Agent: Mutt/1.5.21 (2010-09-15)
Subject: Re: [sisyphus] postgresql index row
X-BeenThere: sisyphus@lists.altlinux.org
X-Mailman-Version: 2.1.12
Precedence: list
Reply-To: ALT Linux Sisyphus discussions <sisyphus@lists.altlinux.org>
List-Id: ALT Linux Sisyphus discussions <sisyphus.lists.altlinux.org>
List-Unsubscribe: <https://lists.altlinux.org/mailman/options/sisyphus>,
	<mailto:sisyphus-request@lists.altlinux.org?subject=unsubscribe>
List-Archive: <http://lists.altlinux.org/pipermail/sisyphus>
List-Post: <mailto:sisyphus@lists.altlinux.org>
List-Help: <mailto:sisyphus-request@lists.altlinux.org?subject=help>
List-Subscribe: <https://lists.altlinux.org/mailman/listinfo/sisyphus>,
	<mailto:sisyphus-request@lists.altlinux.org?subject=subscribe>
X-List-Received-Date: Fri, 12 Nov 2010 16:25:46 -0000
Archived-At: <http://lore.altlinux.org/sisyphus/20101112162542.GB16999@altlinux.org/>
List-Archive: <http://lore.altlinux.org/sisyphus/>
List-Post: <mailto:sisyphus@altlinux.ru>


--bCsyhTFzCvuiizWE
Content-Type: text/plain; charset=koi8-r
Content-Disposition: inline
Content-Transfer-Encoding: quoted-printable

On Fri, Nov 12, 2010 at 06:06:59PM +0200, Igor Zubkov wrote:
> >> =3D=3D =9AAddIndexOnChangelogtext: migrating =3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=3D=
=3D=3D=3D=3D=3D=3D=3D
> >> -- add_index(:changelogs, :changelogtext)
> > =FA=C1=CE=C1=C8=D2=C5=CE=C1?
> =F7=CF=D4 =DE=D4=CF =C2=D9 =D4=C1=CB=CF=CA =DA=C1=D0=D2=CF=D3 =CB =E2=E4 =
=D2=C1=C2=CF=D4=C1=CC =C2=D9=D3=D4=D2=CF, =C1 =CE=C5 =CB=C1=CB =D3=C5=CA=DE=
=C1=D3...
> ree-1.8.7-2010.02 > Changelog.where('changelogtext LIKE \'%CVE%\'').count
>  =3D> 4288
> ree-1.8.7-2010.02 >
"=FB=C1=D2=C9=CB, =D4=D9 =C2=C1=CC=C2=C5=D3!" (=C3)

http://www.postgresql.org/docs/9.0/interactive/indexes-types.html

"""The optimizer can also use a B-tree index for queries
involving the pattern matching operators LIKE and ~ *if* the
pattern is a constant and is anchored to the beginning of the
string -- for example, col LIKE 'foo%' or col ~ '^foo', but
not col LIKE '%bar'."""

--=20
Regards,    --
Sir Raorn.   --- http://thousandsofhate.blogspot.com/

--bCsyhTFzCvuiizWE
Content-Type: application/pgp-signature; name="signature.asc"
Content-Description: Digital signature

-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)

iQIcBAEBAgAGBQJM3WqCAAoJEErPkC6vOrpJSX0P/3cqt8i2OJnGnZ66X4CfkqUV
jb9lTq+hWYuouguZL0nnGHv+BmyulBsqGjKrSgjTz24E64MyAU0GnXjbS7wdliiG
aOmzwHCvVTcdinSyoXzIqJNqpzlmqIGXCJqYBPf0KnuZT9XryfyL2TK1Ktan4EKI
dzlwQRZFQ7dBkYgcfDDYkLXWKKTtNbnTm/Qugzo+is5a8sClrV+XXFSRRzFI0v2F
ohVSXTU7GbNsFRhSYXtm2EiqYs81wIvDCVFfbl3niNUOlWCI9oYis5ytgZLVHVtu
G+B69xnZEfbRxBoht8+YccOcwk0LlTWBCyus0GUTbydYAuqOyyMSZwyQA651XxUF
CIzA/I7m5qktfOCdO/AOQo+Y1LjgPnFQwmQpZ/RboxnhFb3Dn8FzJ0qCmZJ2cLpx
7wIT/FIGIvtdOUQOgotju4Zdmy7GKht/12tTHpkZBJdiFKRepoaG4wK/Xejiwwh6
QCt9Cda6jGQ1E3Jz2FGI7+BJXVhCcsP3tTAqvIYJcvYhb8qxaNwADYxCAAce8U/B
buP8Uj/SWMYFYcGyycJfXrLywqV6vDOcRA7gR9wHTxdxHniQratL5Z9pK6v5zpl3
7Rmyr2biUj5mv6pvyaFa2mAGCW3e6yLX3xZuKR3vjWQsFLI0n2vjRehL1+epIDrG
SiNTQcdfMziNv+Hkojus
=3l35
-----END PGP SIGNATURE-----

--bCsyhTFzCvuiizWE--