Re: query slows under load - Mailing list pgsql-performance

From Stephan Szabo
Subject Re: query slows under load
Date
Msg-id 20040125131051.C13091@megazone.bigpanda.com
Whole thread Raw
In response to query slows under load  (Jenny Zhang <jenny@osdl.org>)
List pgsql-performance
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.

pgsql-performance by date:

Previous
From: Ivan Voras
Date:
Subject: Re: Benchmarking PostgreSQL?
Next
From: "Arnau"
Date:
Subject: Queries with timestamp II