From mboxrd@z Thu Jan 1 00:00:00 1970 Return-Path: Date: Fri, 1 Aug 2008 01:26:46 +0400 From: Alexey Tourbin To: ALT Linux Team development discussions Message-ID: <20080731212646.GK31781@solemn.turbinal> Mail-Followup-To: ALT Linux Team development discussions References: <20080731142110.GA25664@dad.imath.kiev.ua> <20080731173529.GI31781@solemn.turbinal> <20080731192406.GJ31781@solemn.turbinal> <20080731201028.GA31647@dad.imath.kiev.ua> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="LQ77YLfPrO/qF/pM" Content-Disposition: inline In-Reply-To: <20080731201028.GA31647@dad.imath.kiev.ua> Subject: Re: [devel] repocop: arch-dep-package-has-big-usr-share X-BeenThere: devel@lists.altlinux.org X-Mailman-Version: 2.1.10b3 Precedence: list Reply-To: ALT Linux Team development discussions List-Id: ALT Linux Team development discussions List-Unsubscribe: , List-Archive: List-Post: List-Help: List-Subscribe: , X-List-Received-Date: Thu, 31 Jul 2008 21:26:47 -0000 Archived-At: List-Archive: List-Post: --LQ77YLfPrO/qF/pM Content-Type: text/plain; charset=koi8-r Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Thu, Jul 31, 2008 at 11:10:29PM +0300, Igor Vlasenko wrote: > =F3=C5=CA=DE=C1=D3 =D4=C1=CD =CE=C1 =D0=CC=CF=D3=CB=CF=D3=D4=C9 (S,s) =D7= =D9=D2=C5=DA=C1=C5=D4=D3=D1 =D0=C5=D2=D7=CF=C5 =D0=D2=C9=C2=CC=C9=D6=C5=CE= =C9=C5 =CB =C7=C9=D0=C5=D2=C2=CF=CC=C5: > | > | | > | \ _ > |________ >=20 > DELETE FROM t1 WHERE total <=3D 1048576; > DELETE FROM t2 WHERE usrshare <=3D 1048576; > =CF=D4=C2=D2=C1=D3=D9=D7=C1=C0=D4=D3=D1 =D0=C1=CB=C5=D4=D9 =D3 total < 1m= b =C9 =D3 /usr/share/ < 1mb > INSERT INTO t3 SELECT t1.pkgid, total, usrshare FROM t2 LEFT JOIN t1 ON t= 1.pkgid=3Dt2.pkgid WHERE usrshare > 2097152 OR (usrshare > 1048576 AND usrs= hare/total > 0.5); > =DA=C1=D4=C5=CD =D7=D9=C4=C5=CC=D1=C0=D4=D3=D1 =D0=C1=CB=C5=D4=D9 =D3 /us= r/share/ > 2mb =CC=C9=C2=CF /usr/share/> 1mb =C9 s/S >0.5. >=20 > =F7 =D0=D2=C9=CE=C3=C9=D0=C5 =CD=CF=D6=CE=CF =D3=C7=CC=C1=C4=C9=D4=D8,=20 > =D4=CF=CC=D8=CB=CF =CE=C5 =D0=CF=CE=D1=D4=CE=CF, =D3=D4=CF=C9=D4 =CC=C9 = =D2=C1=DA=CD=C5=CE=C9=D7=C1=D4=D8=D3=D1 =CE=C1 =D0=C1=CB=C5=D4=D9 S,s < 1mb. =F5 =D7=C5=D3=C1 =C5=D3=D4=D8 =D0=CF =CB=D2=C1=CA=CE=C5=CA =CD=C5=D2=C5 =CF= =C4=CE=CF =D0=D2=C5=C9=CD=D5=DD=C5=D3=D4=D7=CF: =C5=D3=CC=C9 p=3D1, =D4=CF = =DC=D4=CF =DA=CE=C1=DE=C9=D4, =DE=D4=CF =CC=C9=C2=CF =D7=D3=C5 =C6=C1=CA=CC=D9 =D7 /usr/share, =CC=C9=C2= =CF =D7 =D0=C1=CB=C5=D4=C5 =D7=CF=CF=C2=DD=C5 =CE=C5=D4 =C6=C1=CA=CC=CF=D7 = (=DC=D4=CF =DA=C1=D7=C9=D3=C9=D4 =CF=D4 =D4=CF=C7=CF, =CB=C1=CB =C4=CF=CF=D0=D2=C5=C4= =C5=CC=C9=D4=D8 =C6=D5=CE=CB=C3=C9=C0). =F7 =CC=C0=C2=CF=CD =D3=CC=D5=DE= =C1=C5, =D4=C1=CB=CF=CA =D0=C1=CB=C5=D4 =CF=DE=C5=CE=D8 =D0=D2=CF=D3=D4=CF =D3=C4=C5=CC=C1=D4=D8 noarch (=C4=CF=D3= =D4=C1=D4=CF=DE=CE=CF =D7=D0=C9=D3=C1=D4=D8 "BuildArch: noarch", =CE=C9=DE=C5=C7=CF =D2=C1=D3=D0=C9=CC=C9=D7=C1=D4=D8 =CE=C5 =CE=C1=C4=CF). = (=F0=D2=C1=D7=C4=C1, =CF=D3=CE=CF=D7=CE=CF=CA =D0=C1=CB=C5=D4 =CE=C5=CC=D8= =DA=D1 =D3=C4=C5=CC=C1=D4=D8 noarch.) =E4=CC=D1 =CF=D3=D4=C1=CC=D8=CE=D9=C8 =D0=C1=CB=C5=D4=CF=D7, =CB=CF=D4=CF= =D2=D9=C5 =CE=D5=D6=CE=CF =D2=C1=D3=D0=C9=CC=C9=D7=C1=D4=D8, =CF=D4=CE=CF= =DB=C5=CE=C9=C5 s/S =C2=D5=C4=C5=D4, =D3=CB=C1=D6=C5=CD, =D7 =D2=C1=CA=CF=CE=C5 [0.5..1). (=F0=CF=D1=D3=CE=D1= =C0 =C4=CC=D1 =CF=D3=D4=C1=CC=D8=CE=D9=C8.) =E5=D3=CC=C9 =D2=C1=DA=CD=C5= =D2 =D0=C1=CB=C5=D4=C1 =C2=CC=C9=DA=CF=CB =CB =C8=C1=D2=C1=CB=D4=C5=D2=CE=CF=CD=D5 =D2=C1=DA=CD=C5= =D2=D5 m, =D4=CF p=3Ds/S =DC=D4=CF =C9 =C2=D5=C4=C5=D4 =D7=C5=D3 /usr/share= =DE=C1=D3=D4=C9. =E4=CC=D1 =CD=C1=CC=C5=CE=D8=CB=C9=C8 =D0=C1=CB=C5=D4=CF=D7 =D7=C5=D3 =C2= =D5=C4=C5=D4 =CB=CF=D2=D2=C5=CB=D4=C9=D2=CF=D7=C1=D4=D8=D3=D1 =D7 =CD=C5=CE= =D8=DB=D5=C0 =D3=D4=CF=D2=CF=CE=D5: ps/S, =D0=CF=D4=CF=CD=D5 = =DE=D4=CF =C4=C1=D6=C5 =D0=D2=C9, =D3=CB=C1=D6=C5=CD, s/S=3D0.3 =D0=CF=CC=D5=DE=C1=C5=D4=D3=D1 =D6= =C9=D2=CE=D9=CA =CC=C1=CB=CF=CD=D9=CA =CB=D5=D3=CF=CB. =EB=CF=D2=CF=DE=C5, =CE=C5=D0=D2=C5=D2=D9=D7=CE=C1=D1 =D7=C5=D3=CF=D7=C1=D1 =C6=D5=CE=CB=C3=C9= =D1 =D0=CF=DA=D7=CF=CC=D1=C5=D4 =CC=C5=C7=DE=C5 =CF=D0=D2=C5=C4=C5=CC=C9=D4= =D8, =C7=C4=C5 =C9=D3=CB=C1=D4=D8 =CB=CF=DB=C5=CC=A3=CB. =F0=D2=C1=D7=C4=C1, =DE=C1=D3=D4=CE=D9=CA =D3=CC=D5=DE=C1=CA p=3D1 =D4=CF= =D6=C5 =CC=C5=C7=CB=CF =CF=D4=D3=CC=C5=C4=C9=D4=D8 SQL =DA=C1=D0=D2=CF=D3= =CF=CD: ... WHERE total =3D usrshare; --LQ77YLfPrO/qF/pM Content-Type: application/pgp-signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.9 (GNU/Linux) iEYEARECAAYFAkiSLhYACgkQfBKgtDjnu0Y98ACg56e8YJLp+L1oQQpV6SUlE50t NUUAoJlEIinjMunpnWaiqu1XHj/MhP6d =aRZX -----END PGP SIGNATURE----- --LQ77YLfPrO/qF/pM--