X-Original-To: pgsql-hackers-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 95E955680C for ; Mon, 14 Mar 2005 19:31:55 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 34213-03 for ; Mon, 14 Mar 2005 19:31:52 +0000 (GMT) Received: from sranda.klamovka.kosire.czf (unknown [82.113.63.66]) by svr1.postgresql.org (Postfix) with ESMTP id EFF3256807 for ; Mon, 14 Mar 2005 19:31:50 +0000 (GMT) Received: (qmail 15126 invoked from network); 14 Mar 2005 20:31:51 +0100 Received: from fordfrog.klamovka.kosire.czf (HELO ?192.168.11.101?) (10.15.70.18) by mail.klamovka.kosire.czf with AES256-SHA encrypted SMTP; 14 Mar 2005 20:31:51 +0100 Message-ID: <4235E6A7.6010703@startnet.cz> Date: Mon, 14 Mar 2005 20:31:51 +0100 From: =?windows-1250?Q?Miroslav_=8Aulc?= Organization: StartNet s.r.o. User-Agent: Mozilla Thunderbird 1.0 (X11/20041208) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Tom Lane Cc: pgsql-hackers@postgreSQL.org, pgsql-performance@postgreSQL.org Subject: Re: Avoiding tuple construction/deconstruction during joining References: <42345D24.8070104@startnet.cz> <14577.1110821062@sss.pgh.pa.us> <4235E1EF.2000402@startnet.cz> <29030.1110828155@sss.pgh.pa.us> In-Reply-To: <29030.1110828155@sss.pgh.pa.us> X-Enigmail-Version: 0.89.5.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: multipart/mixed; boundary="------------010303050800020409010001" X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200503/725 X-Sequence-Number: 65527 This is a multi-part message in MIME format. --------------010303050800020409010001 Content-Type: text/plain; charset=windows-1250; format=flowed Content-Transfer-Encoding: 7bit Tom Lane wrote: >=?windows-1250?Q?Miroslav_=8Aulc?= writes: > > >>seriously, I am far below this level of knowledge. But I can contribute >>a test that (maybe) can help. I have rewritten the query so it JOINs the >>varchar() fields (in fact all fields except the IDPK) at the last INNER >>JOIN. Though there is one more JOIN, the query is more than 5 times >>faster (1975.312 ms) :-) >> >> > >That confirms my thought that passing the data up through multiple >levels of join is what's killing us. I'll work on a solution. This >will of course be even less back-patchable to 8.0.* than Ogawa's work, >but hopefully it will fix the issue for 8.1. > > regards, tom lane > > Tom, thank you and the others for help. I'm glad that my problem can help PostgreSQL improve and that there are people like you that understand each little bit of the software :-) Miroslav --------------010303050800020409010001 Content-Type: text/x-vcard; charset=utf-8; name="miroslav.sulc.vcf" Content-Transfer-Encoding: 7bit Content-Disposition: attachment; filename="miroslav.sulc.vcf" begin:vcard fn;quoted-printable:Miroslav =C5=A0ulc n;quoted-printable:=C5=A0ulc;Miroslav org:StartNet s.r.o. adr;quoted-printable;quoted-printable:;;Vrchlick=C3=A9ho 161/5;Praha 5;;150 00;=C4=8Cesk=C3=A1 republika email;internet:miroslav.sulc@startnet.cz title:CEO tel;work:+420 257 225 602 tel;cell:+420 603 711 413 x-mozilla-html:TRUE url:http://www.startnet.cz version:2.1 end:vcard --------------010303050800020409010001--