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 E42FD52838
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Sat,  4 Jun 2005 09:08:00 -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 29074-02
	for <pgsql-performance-postgresql.org@localhost.postgresql.org>;
	Sat,  4 Jun 2005 12:07:52 +0000 (GMT)
Received: from boutiquenumerique.com (boutiquenumerique.com [82.67.9.10])
	by svr1.postgresql.org (Postfix) with ESMTP id CB0225280B
	for <pgsql-performance@postgresql.org>;
	Sat,  4 Jun 2005 09:07:50 -0300 (ADT)
Received: (qmail 6988 invoked from network); 4 Jun 2005 14:07:58 +0200
Received: from unknown (HELO localhost) (boutiquenumerique-lists@192.168.0.4)
	by boutiquenumerique.com with SMTP; 4 Jun 2005 14:07:58 +0200
To: hubert.lubaczewski@eo.pl
Cc: pgsql-performance@postgresql.org
Subject: Re: strategies for optimizing read on rather large tables
References: <20050604081742.GA29123@eo.pl> <op.srue0eroth1vuj@localhost>
	<20050604114132.GB21031@eo.pl>
Message-ID: <op.sruhbejjth1vuj@localhost>
From: PFC <lists@boutiquenumerique.com>
Organization: =?iso-8859-15?Q?La_Boutique_Num=E9rique?=
Content-Type: text/plain; format=flowed; delsp=yes; charset=iso-8859-15
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Date: Sat, 04 Jun 2005 14:07:52 +0200
In-Reply-To: <op.srue0eroth1vuj@localhost>
User-Agent: Opera M2(BETA2)/8.0 (Linux, build 987)
X-Virus-Scanned: by amavisd-new at hub.org
X-Spam-Status: No, hits=0.006 tagged_above=0 required=5 tests=AWL
X-Spam-Level: 
X-Archive-Number: 200506/90
X-Sequence-Number: 12728


>> select advert_id from acr_cache where category_id = ? and region_id = ?
>> order by category_id, region_id, XXX limit 20;

	don't forget to mention all the index columns in the order by, or the  
planner won't use it.