Re: query slows under load

Поиск
Список
Период
Сортировка
От Stephan Szabo
Тема Re: query slows under load
Дата
Msg-id 20040125131051.C13091@megazone.bigpanda.com
обсуждение исходный текст
Ответ на query slows under load  (Jenny Zhang <jenny@osdl.org>)
Список 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 по дате отправления:

Предыдущее
От: Ivan Voras
Дата:
Сообщение: Re: Benchmarking PostgreSQL?
Следующее
От: "Arnau"
Дата:
Сообщение: Queries with timestamp II