Received: from localhost (maia-1.hub.org [200.46.204.191]) by postgresql.org (Postfix) with ESMTP id 6E31A9FB62C for ; Sat, 21 Apr 2007 17:58:21 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.191]) (amavisd-maia, port 10024) with ESMTP id 56624-02 for ; Sat, 21 Apr 2007 17:58:18 -0300 (ADT) X-Greylist: domain auto-whitelisted by SQLgrey-1.7.4 Received: from wr-out-0506.google.com (wr-out-0506.google.com [64.233.184.234]) by postgresql.org (Postfix) with ESMTP id C061F9FB600 for ; Sat, 21 Apr 2007 17:58:18 -0300 (ADT) Received: by wr-out-0506.google.com with SMTP id 70so1235422wra for ; Sat, 21 Apr 2007 13:58:17 -0700 (PDT) DKIM-Signature: a=rsa-sha1; c=relaxed/relaxed; d=gmail.com; s=beta; h=domainkey-signature:received:received:from:to:subject:date:user-agent:references:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:message-id; b=gO8mkKD5XkagmEloldYWOgY1YXy/WP2JgVNSN9zh/c86eCNg+bRSr4Yptsp+Gbe3i0pfEQc1E+Xh3NNoMr6H7weEuH274OtpFlZNsBW43C/BFm29aalBMAczZTEtyNU2+v7qr/Uw/cFp6bhJ0lLoeW8wGRrrxPJm7r5nSBRRM8g= DomainKey-Signature: a=rsa-sha1; c=nofws; d=gmail.com; s=beta; h=received:from:to:subject:date:user-agent:references:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:message-id; b=RP7o5WpAc/STHLF94qBJkVNywaafOf994pDnLM4+C9epigpuNEngevq1Xa5JmQx6KV5+RLxeLFmEoJYC1gGf3MNZMkk/kQuqBH+kPqrENJ5ONHS6u9xAKq+eeGSZNh7nr5OpiTNfimWJYUgnYh+d5uLtjLWG0Koxnbuy0R5HXXg= Received: by 10.66.244.10 with SMTP id r10mr3868583ugh.1177189096911; Sat, 21 Apr 2007 13:58:16 -0700 (PDT) Received: from v6j.local ( [213.136.175.74]) by mx.google.com with ESMTP id 27sm1545721ugp.2007.04.21.13.58.14; Sat, 21 Apr 2007 13:58:16 -0700 (PDT) From: Vincenzo Romano To: pgsql-performance@postgresql.org Subject: Re: not using indexes on large table Date: Sat, 21 Apr 2007 22:58:06 +0200 User-Agent: KMail/1.9.6 References: <20070421201742.GB99389@penrose.jmkdomain.lan> In-Reply-To: <20070421201742.GB99389@penrose.jmkdomain.lan> MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 7bit Content-Disposition: inline Message-Id: <200704212258.07094.vincenzo.romano@gmail.com> X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200704/362 X-Sequence-Number: 24239 On Saturday 21 April 2007 22:17:42 Jeroen Kleijer wrote: > I've tried several things but doing a query like: > select distinct volume from project_access_times I'm new too but an "order by volume" could help! In any case maybe a different table design with a separate table for the "distinct volumes" could help even more. -- Vincenzo Romano ---- Maybe Computers will never become as intelligent as Humans. For sure they won't ever become so stupid.