Best way to return Random rows from a table with non-repeatability of rows

Поиск
Список
Период
Сортировка
От Kiran
Тема Best way to return Random rows from a table with non-repeatability of rows
Дата
Msg-id CAJfd1U582MsRXqhjt4JMvtTpd0p+f1FAXsRF9Y+zNuXiyZ45xw@mail.gmail.com
обсуждение исходный текст
Ответы Re: Best way to return Random rows from a table with non-repeatability of rows  (Chris Mair <chris@1006.org>)
Список pgsql-general
Дерево обсуждения
Dear folks,

I have a table with thousands of rows ( currently 15 thousand but will grow very fast).
I need to return from the query rows which are random and non-repeating. 
 I know there is random() function, but would like to know from postgresql practitioners before embarking that path.
Please let me know what is best way to handle this type of queries.

regards
Kiran


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

Предыдущее
От: Alexander Farber
Дата:
Сообщение: Re: WHERE ... IN condition and multiple columns in subquery
Следующее
От: Kim Rose Carlsen
Дата:
Сообщение: Re: How to hint 2 coulms IS NOT DISTINCT FROM each other