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=nSh2wFu9T1+DUPYkBNTugH7QU1N19THP/E9OU3hgwAI=; b=XETFClS0YoJ6/37yElxh9b/NZJzc9hF62J0jEHk4xosuXAWk1BGX+ao6yO7acPw6p3 DiHbItRzb9rFZUx0hi0ljMIWGWjlDwDQV5T9HgsBv3tA2s/PafmZwbLboCnf+QTTxw8c aIVit3uxZLtBu+uTu1wxMQBOxGHIsonbJ6Z0w= 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=LfbYVjvsXJnmUEDPoLtL6Ku1dhpXfyrfyG4aVnmF+gW6cRlEYdo6eyBlxsQyX2fqwn 0iQc5dQ27c9V4F30eQcqkOnTp99Cg97Mmeit0wSaWTXk70uzrsMd6WaXvTWDkoD8Q4o8 LhQWTcCi307D7bC1v+zuOx3MJvhTX8qb3dBfI= Sender: Denis Smirnov Date: Sat, 13 Nov 2010 11:49:04 +0300 From: "=?koi8-r?B?5MXOydMg883J0s7P1w==?=" To: ALT Linux Sisyphus discussions Message-ID: <20101113084904.GA7348@mw.mithraen.ru> References: <20101112074704.GA16999@altlinux.org> <20101112163923.GA2748@mw.mithraen.ru> <20101113092310.306f08b2@satellite.immomsk.ru> MIME-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="opJtzjQTFsWo+cga" Content-Disposition: inline In-Reply-To: <20101113092310.306f08b2@satellite.immomsk.ru> 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: Sat, 13 Nov 2010 08:49:17 -0000 Archived-At: List-Archive: List-Post: --opJtzjQTFsWo+cga Content-Type: text/plain; charset=koi8-r Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Sat, Nov 13, 2010 at 09:23:10AM +0300, Alex Gorbachenko wrote: AG> =D3=D4=D2=CF=C7=CF =C7=CF=D7=CF=D2=D1, =CC=D5=DE=DB=C5 =D4=D2=C9 =D4=C1= =C2=CC=C9=DE=CB=C9. id(PK),package_name -< AG> id(PK),)(package_id,package_version)UNIQUE) -< id(PK),((name_version_id, AG> CVE)UNIQUE). =C9=CE=C4=C5=CB=D3=D9 =CF=DE=C5=D7=C9=C4=CE=D9. AG> join =D7 =C4=C1=CE=CE=CF=CD =D3=CC=D5=DE=C1=C5 =C4=C5=DB=A3=D7=D9=CA. =E5=D3=CC=C9 =C4=CC=D1 package_name =C9=D3=D0=CF=CC=D8=DA=CF=D7=C1=D4=D8 ha= sh-index'=D9, =D4=CF =C5=D3=CC=C9 =D1 =D0=D2=C1=D7=C9=CC=D8=CE=CF =D0=CF=CE= =C9=CD=C1=C0 -- =DC=D4=CF=D4 =D7=C1=D2=C9=C1=CE=D4 =C2=D5=C4=C5=D4 =C4=C1=D6=C5 =DE=D5=D4= =CF=DE=CB=D5 =CD=C5=C4=CC=C5=CE=CE=C5=C5. AG> =C9 =DC=D4=CF =D0=D2=C1=D7=C9=CC=D8=CE=CF, =CE=CF tsearch2 =D7=D3=A3 = =D2=C1=D7=CE=CF =D0=D2=C9=C4=A3=D4=D3=D1 =CF=D3=C9=CC=C9=D4=D8 =C4=CC=D1 = =D0=CF=C9=D3=CB=C1 =D0=CF AG> =CF=D0=C9=D3=C1=CE=C9=D1=CD =D0=C1=CB=C5=D4=CF=D7 =C9 =D4=C5=CD =D6=C5 = =D3=D0=C9=D3=CB=C1=CD =C9=DA=CD=C5=CE=C5=CE=C9=CA. =CF=D3=C9=CC=C9=D7=C1=D4= =D8 =D4=C1=CD =D2=CF=D7=CE=CF 2 AG> =D3=D4=D2=C1=CE=C9=C3=D9 =D4=C5=CB=D3=D4=C1. =FC=D4=CF =C4=C1. =EB=D3=D4=C1=D4=C9 =D1 =D0=CF=CB=C1 =D4=C1=CB =C9 =CE=C5 = =CF=D3=C9=CC=C9=CC :) --=20 =F3 =D5=D7=C1=D6=C5=CE=C9=C5=CD, =E4=C5=CE=C9=D3 http://mithraen.ru/ ---------------------------------------------------------------------------- --opJtzjQTFsWo+cga Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.11 (GNU/Linux) iEYEARECAAYFAkzeUP4ACgkQPuR8c4jhFKKn/QCfaB60nICjfdb2WwskypqoIDgW xmIAniq6+Hk+4gpJ3LPJHZmYrwlnzesf =Ssie -----END PGP SIGNATURE----- --opJtzjQTFsWo+cga--