Re: Multiple Order By Criteria

От: J@Planeti.Biz
Тема: Re: Multiple Order By Criteria
Дата: ,
Msg-id: 003201c61bc5$6652d690$81300d05@fatchubby
(см: обсуждение, исходный текст)
Ответ на: Multiple Order By Criteria  ()
Ответы: Re: Multiple Order By Criteria  ("Ahmad Fajar")
Список: pgsql-performance

Скрыть дерево обсуждения

Multiple Order By Criteria  (, )
 Re: Multiple Order By Criteria  (Josh Berkus, )
  Re: Multiple Order By Criteria  (Stephan Szabo, )
 Re: Multiple Order By Criteria  (, )
  Re: Multiple Order By Criteria  (Fredrick O Jackson, )
 Re: Multiple Order By Criteria  (, )
  Re: Multiple Order By Criteria  (Stephan Szabo, )
 Re: Multiple Order By Criteria  (, )
  Re: Multiple Order By Criteria  ("Ahmad Fajar", )
   Re: Multiple Order By Criteria  (, )
    Re: Multiple Order By Criteria  (Stephan Szabo, )
   Re: Multiple Order By Criteria  (, )

I've read all of this info, closely. I wish when I was searching for an
answer for my problem these pages came up. Oh well.

I am getting an idea of what I need to do to make this work well. I was
wondering if there is more information to read on how to implement this
solution in a more simple way. Much of what's written seems to be towards an
audience that should understand certain things automatically.
----- Original Message -----
From: "Stephan Szabo" <>
To: <>
Cc: "Josh Berkus" <>; <>
Sent: Tuesday, January 17, 2006 6:39 PM
Subject: Re: [PERFORM] Multiple Order By Criteria


>
> On Tue, 17 Jan 2006  wrote:
>
>> I created the index like this:
>>
>> CREATE INDEX rcbee_idx
>>   ON detail_summary
>>   USING btree
>>   (receipt, carrier_id, batchnum, encounternum, encounter_id);
>>
>> Is this correct ?
>
> That would work if you were asking for all the columns ascending or
> descending, but we don't currently use it for mixed orders.
>
>> How do I make a reverse opclass ?
>
> There's some information at the following:
> http://archives.postgresql.org/pgsql-novice/2005-10/msg00254.php
> http://archives.postgresql.org/pgsql-general/2005-01/msg00121.php
> http://archives.postgresql.org/pgsql-general/2004-06/msg00565.php
>
> ---------------------------(end of broadcast)---------------------------
> TIP 6: explain analyze is your friend
>



В списке pgsql-performance по дате сообщения:

От: Mark Kirkwood
Дата:
Сообщение: Re: Suspending SELECTs
От: Alessandro Baretta
Дата:
Сообщение: Re: Suspending SELECTs