X-Original-To: pgsql-performance-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id B1DF7D1D287 for ; Sun, 25 Jan 2004 21:14:50 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 57895-03 for ; Sun, 25 Jan 2004 17:14:20 -0400 (AST) Received: from megazone.bigpanda.com (megazone.bigpanda.com [64.147.171.210]) by svr1.postgresql.org (Postfix) with ESMTP id 03F4ED1D2AA for ; Sun, 25 Jan 2004 17:14:19 -0400 (AST) Received: by megazone.bigpanda.com (Postfix, from userid 1001) id 662EE35502; Sun, 25 Jan 2004 13:14:05 -0800 (PST) Received: from localhost (localhost [127.0.0.1]) by megazone.bigpanda.com (Postfix) with ESMTP id 64FCF34DBC; Sun, 25 Jan 2004 13:14:05 -0800 (PST) Date: Sun, 25 Jan 2004 13:14:05 -0800 (PST) From: Stephan Szabo To: Jenny Zhang Cc: perf-pgsql , dbt-general Subject: Re: query slows under load In-Reply-To: <1074908063.18586.31.camel@ibm-a.pdx.osdl.net> Message-ID: <20040125131051.C13091@megazone.bigpanda.com> References: <1074908063.18586.31.camel@ibm-a.pdx.osdl.net> MIME-Version: 1.0 Content-Type: TEXT/PLAIN; charset=US-ASCII X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/265 X-Sequence-Number: 5439 On Fri, 23 Jan 2004, Jenny Zhang wrote: > 3. index with desc/asc is not supported in PG, why it is not needed? Is > there any work-around? You can do this with index operator classes. There aren't any automatically provided ones that do the reversed sort iirc, but I think that's come up before with examples. I've toyed with the idea of writing the reverse opclasses for at least some of the types, but haven't been seriously motivated to actually get it done.