Received: from maia.hub.org (unknown [200.46.204.183])
	by mail.postgresql.org (Postfix) with ESMTP id 80A4C6329D3
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Fri, 16 Apr 2010 10:58:39 -0300 (ADT)
Received: from mail.postgresql.org ([200.46.204.86])
	by maia.hub.org (mx1.hub.org [200.46.204.183]) (amavisd-maia,
	port 10024) with ESMTP id 69786-05
	for <pgsql-performance-postgresql.org@mail.postgresql.org>;
	Fri, 16 Apr 2010 13:58:28 +0000 (UTC)
X-Greylist: domain auto-whitelisted by SQLgrey-1.7.6
Received: from mail-wy0-f174.google.com (mail-wy0-f174.google.com
	[74.125.82.174])
	by mail.postgresql.org (Postfix) with ESMTP id C4DBB63229D
	for <pgsql-performance@postgresql.org>;
	Fri, 16 Apr 2010 10:58:28 -0300 (ADT)
Received: by wyb39 with SMTP id 39so1156822wyb.19
	for <pgsql-performance@postgresql.org>;
	Fri, 16 Apr 2010 06:58:26 -0700 (PDT)
DKIM-Signature: v=1; a=rsa-sha256; c=relaxed/relaxed; d=gmail.com; s=gamma;
	h=domainkey-signature:mime-version:received:in-reply-to:references
	:date:received:message-id:subject:from:to:cc:content-type;
	bh=3brAqMaJLHNCzL8BVINA9q9VpdFbCrW5bq/JQ1Ebcaw=;
	b=n6WUdfFco+WPxHsyzdWbl4I0cUYnmdgbeN/Mpecl706+l3Zj1KwJiHsW2FJatQKcli
	Gr4OsLzxR/t7sPpIQyYVCc041qPTgJfDL2wKRewQj4C2DZTHWsPJ3jaEaLh5mLwGIpa5
	Lgj7PhsNYqxqbpRJhK5J6HWSAxCIxHDA6du1U=
DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=gamma;
	h=mime-version:in-reply-to:references:date:message-id:subject:from:to
	:cc:content-type;
	b=dykf+mdmk5TEf/U87X/GZHZz280rNpd9B9RZ0/NLA2UfbMXC+wdVxgFQT0UnpYIPBg
	RnKDZj0IB9gNr/87Re/kD0Hcl7Jbv9xieNFftwUxCBHfMmRWP8sLf/wfBdA1LCUgVcAo
	Sg/O8QC9cqCCyAo1BufFESVDS3Hm2oTnR7KCE=
MIME-Version: 1.0
Received: by 10.216.25.194 with HTTP; Fri, 16 Apr 2010 06:58:22 -0700 (PDT)
In-Reply-To: <4BC8645A.2060700@gmail.com>
References: <m2y331e40661004160102tff445f9eg165a04efe3b409ed@mail.gmail.com>
	<4BC8204A.7050904@gmail.com>
	<k2u331e40661004160549td6bf86d5pb6fde70e6d1ab5d@mail.gmail.com>
	<4BC8645A.2060700@gmail.com>
Date: Fri, 16 Apr 2010 16:58:22 +0300
Received: by 10.216.91.9 with SMTP id g9mr1864777wef.194.1271426306503; Fri,
	16 Apr 2010 06:58:26 -0700 (PDT)
Message-ID: <u2s331e40661004160658s842c95d4x22d212dc8cdbbb4e@mail.gmail.com>
Subject: Re: Planner not using column limit specified for one column
	for another column equal to first
From: =?KOI8-U?B?96bUwcymyiD0yc3eydvJzg==?= <tivv00@gmail.com>
To: Yeb Havinga <yebhavinga@gmail.com>
Cc: pgsql-performance@postgresql.org
Content-Type: multipart/mixed; boundary=0016e6d99f6a5b75b104845b01e6
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=1.554 tagged_above=-10 required=5
	tests=BAYES_40=-0.001, FREEMAIL_ENVFROM_END_DIGIT=1.553,
	FREEMAIL_FROM=0.001, HTML_MESSAGE=0.001
X-Spam-Level: *
X-Archive-Number: 201004/203
X-Sequence-Number: 38453

--0016e6d99f6a5b75b104845b01e6
Content-Type: multipart/alternative; boundary=0016e6d99f6a5b75a704845b01e4

--0016e6d99f6a5b75a704845b01e4
Content-Type: text/plain; charset=KOI8-U
Content-Transfer-Encoding: quoted-printable

16 =CB=D7=A6=D4=CE=D1 2010 =D2. 16:21 Yeb Havinga <yebhavinga@gmail.com> =
=CE=C1=D0=C9=D3=C1=D7:

> =F7=A6=D4=C1=CC=A6=CA =F4=C9=CD=DE=C9=DB=C9=CE wrote:
>
>>
>> BTW: Changing slow query to inner joins do not make it fast
>>
> I'm interested to see the query andplan of the slow query with inner join=
s.
>
>
> Here you are. The query:

select * from company this_ inner join company_tag this_1_ on
this_.id=3Dthis_1_.company_id
inner join company_measures companymea2_ on
this_.id=3Dcompanymea2_.company_id
inner join company_descr ces3_ on this_.id=3Dces3_.company_id
where this_1_.tag_id =3D 7 and this_.id>50000000
order by this_.id asc
limit 1000
;
Total runtime: 14088.942 ms
(plan is attached)

Best regards, Vitalii Tymchyshyn

--0016e6d99f6a5b75a704845b01e4
Content-Type: text/html; charset=KOI8-U
Content-Transfer-Encoding: quoted-printable

<br><br><div class=3D"gmail_quote">16 =CB=D7=A6=D4=CE=D1 2010 =D2. 16:21 Ye=
b Havinga <span dir=3D"ltr">&lt;<a href=3D"mailto:yebhavinga@gmail.com">yeb=
havinga@gmail.com</a>&gt;</span> =CE=C1=D0=C9=D3=C1=D7:<br><blockquote clas=
s=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1px #ccc solid;pad=
ding-left:1ex;">
<div class=3D"im">=F7=A6=D4=C1=CC=A6=CA =F4=C9=CD=DE=C9=DB=C9=CE wrote:<br>
<blockquote class=3D"gmail_quote" style=3D"margin:0 0 0 .8ex;border-left:1p=
x #ccc solid;padding-left:1ex">
<br>
BTW: Changing slow query to inner joins do not make it fast<br>
</blockquote></div>
I&#39;m interested to see the query andplan of the slow query with inner jo=
ins.<div class=3D"im"><br><br></div></blockquote><div>Here you are. The que=
ry:</div><div><br></div><div>select * from company this_ inner join company=
_tag this_1_ on this_.id=3Dthis_1_.company_id=9A</div>
<div>inner join company_measures companymea2_ on this_.id=3Dcompanymea2_.co=
mpany_id=9A</div><div>inner join company_descr ces3_ on this_.id=3Dces3_.co=
mpany_id=9A</div><div>where this_1_.tag_id =3D 7 and this_.id&gt;50000000=
=9A</div><div>
order by this_.id asc</div><div>limit 1000</div><div>;=9A</div><div>Total r=
untime: 14088.942 ms</div><div>(plan is attached)</div><div><br></div><div>=
Best regards, Vitalii Tymchyshyn</div></div>

--0016e6d99f6a5b75a704845b01e4--

--0016e6d99f6a5b75b104845b01e6
Content-Type: text/plain; charset=US-ASCII; name="innerplan.txt"
Content-Disposition: attachment; filename="innerplan.txt"
Content-Transfer-Encoding: base64
X-Attachment-Id: f_g832by020

TGltaXQgIChjb3N0PTIyNy4xNS4uODgzLjIyIHJvd3M9MTAwMCB3aWR0aD0xMjA5KSAoYWN0dWFs
IHRpbWU9MTQwNjIuMTA2Li4xNDA4Ny4zNzUgcm93cz0xMDAwIGxvb3BzPTEpCiAgLT4gIE1lcmdl
IEpvaW4gIChjb3N0PTIyNy4xNS4uNDM1NTI3Ny43MCByb3dzPTY2MzgwNDYgd2lkdGg9MTIwOSkg
KGFjdHVhbCB0aW1lPTE0MDYyLjEwMS4uMTQwODQuNTc3IHJvd3M9MTAwMCBsb29wcz0xKQogICAg
ICAgIE1lcmdlIENvbmQ6ICh0aGlzXy5pZCA9ICh0aGlzXzFfLmNvbXBhbnlfaWQpOjpiaWdpbnQp
CiAgICAgICAgLT4gIE1lcmdlIEpvaW4gIChjb3N0PTE4NS4xNC4uNDAyNTk3OC41OSByb3dzPTY3
NTczNTggd2lkdGg9MTE5MykgKGFjdHVhbCB0aW1lPTEwNjkyLjk3NS4uMTA3MDguOTIzIHJvd3M9
MTA1NCBsb29wcz0xKQogICAgICAgICAgICAgIE1lcmdlIENvbmQ6ICgoY29tcGFueW1lYTJfLmNv
bXBhbnlfaWQpOjpiaWdpbnQgPSB0aGlzXy5pZCkKICAgICAgICAgICAgICAtPiAgTWVyZ2UgSm9p
biAgKGNvc3Q9MC4wMC4uMTc4NDU3NC40NCByb3dzPTY4MjE2NzIgd2lkdGg9NTcwKSAoYWN0dWFs
IHRpbWU9MC4xMTEuLjkxMzguODA0IHJvd3M9MTA5NzA5NiBsb29wcz0xKQogICAgICAgICAgICAg
ICAgICAgIE1lcmdlIENvbmQ6ICgoY29tcGFueW1lYTJfLmNvbXBhbnlfaWQpOjpiaWdpbnQgPSAo
Y2VzM18uY29tcGFueV9pZCk6OmJpZ2ludCkKICAgICAgICAgICAgICAgICAgICAtPiAgSW5kZXgg
U2NhbiB1c2luZyBwa19jb21wX21zIG9uIGNvbXBhbnlfbWVhc3VyZXMgY29tcGFueW1lYTJfICAo
Y29zdD0wLjAwLi40NTYzNTAuMzYgcm93cz02ODIxNjcyIHdpZHRoPTY4KSAoYWN0dWFsIHRpbWU9
MC4wNjYuLjE3NDcuMjkxIHJvd3M9MTA5NzA5NiBsb29wcz0xKQogICAgICAgICAgICAgICAgICAg
IC0+ICBJbmRleCBTY2FuIHVzaW5nIGN3c19jb21wYW55X2Rlc2NyX3VuaXF1ZSBvbiBjb21wYW55
X2Rlc2NyIGNlczNfICAoY29zdD0wLjAwLi4xMjI1ODk5LjAwIHJvd3M9NjgyMTY3MiB3aWR0aD01
MDIpIChhY3R1YWwgdGltZT0wLjAzMy4uMTgyMi4wODUgcm93cz0xMDk3MDk2IGxvb3BzPTEpCiAg
ICAgICAgICAgICAgLT4gIEluZGV4IFNjYW4gdXNpbmcgcGtfY29tcF9tIG9uIGNvbXBhbnkgdGhp
c18gIChjb3N0PTAuMDAuLjIxMzkzMjQuNTMgcm93cz02ODg2NTk4IHdpZHRoPTYyMykgKGFjdHVh
bCB0aW1lPTAuMDI2Li4xLjg1MyByb3dzPTEwNTQgbG9vcHM9MSkKICAgICAgICAgICAgICAgICAg
ICBJbmRleCBDb25kOiAodGhpc18uaWQgPiA1MDAwMDAwMCkKICAgICAgICAtPiAgSW5kZXggU2Nh
biB1c2luZyBjb21wYW55X3RhZ19jb21wYW55X2lkX2lkeCBvbiBjb21wYW55X3RhZyB0aGlzXzFf
ICAoY29zdD0wLjAwLi4yMjkxNjcuNTYgcm93cz02NzY1MDA0IHdpZHRoPTE2KSAoYWN0dWFsIHRp
bWU9MC4wMjguLjE4NTkuOTY3IHJvd3M9MTA3NTYzNCBsb29wcz0xKQogICAgICAgICAgICAgIEZp
bHRlcjogKCh0aGlzXzFfLnRhZ19pZCk6OmJpZ2ludCA9IDcpClRvdGFsIHJ1bnRpbWU6IDE0MDg4
Ljk0MiBtcwoK
--0016e6d99f6a5b75b104845b01e6--