order by

Поиск
Список
Период
Сортировка
От Marc Millas
Тема order by
Дата
Msg-id CADX_1ab4n123_T4N_mkHEBO1uPVh2i2bzXoo7pzPJknxWJP1dw@mail.gmail.com
обсуждение исходный текст
Ответы Re: order by
Re: order by
Re: order by
Список pgsql-general
Hi,

I keep on investigating on the "death postgres" subject
but open a new thread as I don't know if it's related to my pb.

I have 2 different clusters, on 2 different machines, one is prod, the second test.
Same data volumes.

On prod if I do  
select col_a, count(col_a) from table_a group by col_a order by col_a desc, 
I get the numbers of NULL on top.
To get the number of NULL on top on the test db, I have to 
select col_a, count(col_a) from table_a group by col_a order by col_a asc.

so, it looks like there is something different within the b-tree operator class of varchar (?!?)
between those 2 clusters.

What can I check to to explain this difference as, to my understanding, it's not a postgresql.conf parameter.

thanks

Marc MILLAS
Senior Architect
+33607850334

В списке pgsql-general по дате отправления:

Предыдущее
От: Marc Millas
Дата:
Сообщение: Re: Death postgres
Следующее
От: Marc Millas
Дата:
Сообщение: gather merge