X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id B27225284B for ; Sat, 4 Jun 2005 09:13:31 -0300 (ADT) 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 32751-04 for ; Sat, 4 Jun 2005 12:13:28 +0000 (GMT) Received: from viper.eo.pl (viper.eo.pl [217.17.46.133]) by svr1.postgresql.org (Postfix) with ESMTP id 3F2D15283B for ; Sat, 4 Jun 2005 09:13:27 -0300 (ADT) Received: from xxx.hq.eo.pl ([192.168.20.129] helo=localhost.localdomain) by viper with esmtpsa (TLS-1.0:RSA_AES_256_CBC_SHA:32) (Exim 4.50) id 1DeXWn-00029O-SI; Sat, 04 Jun 2005 14:13:30 +0200 Received: from depesz by localhost.localdomain with local (Exim 4.50) id 1DeXWh-0006cE-TT; Sat, 04 Jun 2005 14:13:19 +0200 Date: Sat, 4 Jun 2005 14:13:19 +0200 From: hubert lubaczewski To: PFC Cc: pgsql-performance@postgresql.org Subject: Re: strategies for optimizing read on rather large tables Message-ID: <20050604121319.GA25309@eo.pl> Reply-To: hubert.lubaczewski@eo.pl References: <20050604081742.GA29123@eo.pl> <20050604114132.GB21031@eo.pl> Mime-Version: 1.0 Content-Type: multipart/signed; micalg=pgp-sha1; protocol="application/pgp-signature"; boundary="mP3DRpeJDSE+ciuQ" Content-Disposition: inline In-Reply-To: X-info-en-1: this message *may* reflect my personal opinion. it is *not* X-info-en-2: intended to reflect those of my employer, or anyone else. X-info-pl-1: wszelkie opinie =?iso-8859-2?Q?wyra=BFone_?= =?iso-8859-2?Q?w_tym_li=B6cie_prezentuj=B1_wy=B3=B1cznie_pogl=B1dy?= X-info-pl-2: autora listu. opinie =?iso-8859-2?Q?te_?= =?iso-8859-2?Q?w_=BFadnym__razie_nie__wyra=BFaj=B1__pogl=B1d=F3w?= X-info-pl-3: pracodawcy autora =?iso-8859-2?Q?listu_?= =?iso-8859-2?Q?_ani__innych__zwi=B1zanych__z__nim__os=F3b=2E?= User-Agent: Mutt/1.5.9i X-Virus-Scanned: by amavisd-new at hub.org X-Archive-Number: 200506/91 X-Sequence-Number: 12729 --mP3DRpeJDSE+ciuQ Content-Type: text/plain; charset=iso-8859-2 Content-Disposition: inline Content-Transfer-Encoding: quoted-printable On Sat, Jun 04, 2005 at 02:07:52PM +0200, PFC wrote: > don't forget to mention all the index columns in the order by, or=20 > the planner won't use it. of course. i understand the concept. actually i find kind of ashamed i did not try it before.=20 anyway - thanks for great tip. depesz --mP3DRpeJDSE+ciuQ Content-Type: application/pgp-signature; name="signature.asc" Content-Description: Digital signature Content-Disposition: inline -----BEGIN PGP SIGNATURE----- Version: GnuPG v1.4.0 (GNU/Linux) iD8DBQFCoZrf5ZmPxbV4/n4RAvY1AJsFTqKsvN45qU63IsD+VhlgFMicSQCdEA+d Zfnny8+5u2ZbX7hSRCSuPIE= =FRkC -----END PGP SIGNATURE----- --mP3DRpeJDSE+ciuQ--