Re: What is the right way to deal with a table with rows that are not in a random order?

Поиск
Список
Период
Сортировка
От Scott Marlowe
Тема Re: What is the right way to deal with a table with rows that are not in a random order?
Дата
Msg-id dcc563d10905280741j45fb5721qc1b79e68af3b4f39@mail.gmail.com
обсуждение исходный текст
Ответ на Re: What is the right way to deal with a table with rows that are not in a random order?  (Scott Marlowe <scott.marlowe@gmail.com>)
Ответы Re: What is the right way to deal with a table with rows that are not in a random order?  (Douglas Alan <darkwater42@gmail.com>)
Список pgsql-general
Дерево обсуждения 
Note that in the OPs case I'd probably try testing things like turning
off seqscan, or lowering random_page_cost.  I'd also look at
clustering on the index for the field you're selecting on.

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

Предыдущее
От: Scott Marlowe
Дата:
Сообщение: Re: What is the right way to deal with a table with rows that are not in a random order?
Следующее
От: inf200468@ucf.edu.cu
Дата:
Сообщение: [Fwd: Re: a modo texto]