From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: X-Spam-Checker-Version: SpamAssassin 3.2.5 (2008-06-10) on sa.int.altlinux.org X-Spam-Level: X-Spam-Status: No, score=-1.5 required=5.0 tests=BAYES_00, DNS_FROM_OPENWHOIS, SPF_PASS autolearn=no version=3.2.5 DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma; h=domainkey-signature:received:received:sender:date:from:to:subject :message-id:references:mime-version:content-type:content-disposition :in-reply-to; bh=+sYAKI2JFQY+In6OKauFwh7T5H36kCoM+yyJXGjxibc=; b=o06U9EZh9AfTaU/zBXYGx8YIhnnkAqJ97xwH5x+xd9WgkOGMbnologsqW4O+ofDlNi 3STweODzzJ3OBQI6S3KaZiX9Fcq5XGvwl/BHqKDrT+waqxYsk2QcoCF/xAc9uaJFF1zR +1/MidgiIRNZ3BwyVQQZTfdgRcvYATwRBxMfM= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma; h=sender:date:from:to:subject:message-id:references:mime-version :content-type:content-disposition:in-reply-to; b=eIxRZOZlRDiUAC7C+6ZYv2clv24E8Zocs+/G9cIgEXRclbvRxlTaGzFKqT2pwUZOrz nU8xzVgFDxJHEsfy9KGsjYFLt6B5sd+muWLAfoP/hqgQ/eGDgf8RtR6yDZGGVGU2VrcW 5FKl6Va/YB5tduuIfZrUwuVts8frHi2trzuMM= Sender: Denis Smirnov Date: Fri, 12 Nov 2010 19:44:02 +0300 From: "=?koi8-r?B?5MXOydMg883J0s7P1w==?=" To: ALT Linux Sisyphus discussions Message-ID: <20101112164402.GB2748@mw.mithraen.ru> References: <20101112074704.GA16999@altlinux.org> <20101112162542.GB16999@altlinux.org> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="2B/JsCI69OhZNC5r" Content-Disposition: inline In-Reply-To: <20101112162542.GB16999@altlinux.org> 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 List-Id: ALT Linux Sisyphus discussions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Fri, 12 Nov 2010 16:44:13 -0000 Archived-At: List-Archive: List-Post: --2B/JsCI69OhZNC5r Content-Type: text/plain; charset=koi8-r Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Fri, Nov 12, 2010 at 07:25:42PM +0300, Alexey I. Froloff wrote: AIF> "=FB=C1=D2=C9=CB, =D4=D9 =C2=C1=CC=C2=C5=D3!" (=C3) AIF> http://www.postgresql.org/docs/9.0/interactive/indexes-types.html AIF> """The optimizer can also use a B-tree index for queries AIF> involving the pattern matching operators LIKE and ~ *if* the AIF> pattern is a constant and is anchored to the beginning of the AIF> string -- for example, col LIKE 'foo%' or col ~ '^foo', but AIF> not col LIKE '%bar'.""" =E4=CF=C2=C1=D7=CC=C0 -- =C5=D3=CC=C9 =D0=CF=CE=C9=CD=C1=D4=D8 =CB=C1=CB = =D2=C1=C2=CF=D4=C1=C5=D4 b-tree =C9=CE=C4=C5=CB=D3, =D4=CF =D3=D4=C1=CE=CF= =D7=C9=D4=D3=D1 =CF=DE=C5=D7=C9=C4=CE=D9=CD =DE=D4=CF =D2=C1=C2=CF=D4=C1=D4=D8 =C9=CE=C1=DE= =C5 =CF=CE=CF =CE=C5 =CD=CF=D6=C5=D4. =E9=C2=CF =CF=CE =D0=CF=CD=CF=C7=C1=C5=D4 =D4=CF=CC=D8=CB=CF =C4=CC=D1 =CF= =D0=C5=D2=C1=C3=C9=CA =D3=D2=C1=D7=CE=C5=CE=C9=D1. =F0=D2=C9 =DC=D4=CF=CD x= like 'abc%' =DC=D4=CF =D4=CF =D6=C5 =D3=C1=CD=CF=C5 =DE=D4=CF: (x >=3D 'abc' AND x < 'abd'), =C9 = =D4=CF=CC=D8=CB=CF =D0=CF=DC=D4=CF=CD=D5 =C9=CE=C4=C5=CB=D3 =D0=CF=CD=CF=C7=C1=C5=D4 =D7 =DC=D4=CF=CA =D3=C9=D4=D5=C1=C3=C9=C9 =C9=D3= =CB=C1=D4=D8. =F0=D2=C9 =DC=D4=CF=CD =C9=CE=C4=C5=CB=D3=D9 =D0=CF =C2=CF=CC=D8=DB=C9=CD = =D3=D4=D2=CF=CB=C1=CD -- =C2=C5=DA=D5=D3=CC=CF=D7=CE=CF=C5 =DA=CC=CF, =C1 = =C9=C8 =D6=C5=CC=C1=CE=C9=C5 =C7=CF=D7=CF=D2=C9=D4 =CF =CE=C5=CF=C2=C8=CF=C4=C9=CD=CF=D3=D4=C9 =D0=D2=C9= =D7=C5=D3=D4=C9 =D3=D4=D2=D5=CB=D4=D5=D2=D5 =C2=C1=DA=D9 =D7 =D0=CF=D2=D1= =C4=CF=CB. --=20 =F3 =D5=D7=C1=D6=C5=CE=C9=C5=CD, =E4=C5=CE=C9=D3 http://mithraen.ru/ ---------------------------------------------------------------------------- --2B/JsCI69OhZNC5r Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) iEYEARECAAYFAkzdbtIACgkQPuR8c4jhFKJJ1wCgseAhrIELzHcTaRBwGQJMOQH/ P5wAoLQLtrFe770XTLqPrrSsN1Nj6lZl =4DtC -----END PGP SIGNATURE----- --2B/JsCI69OhZNC5r--