Re: not using indexes on large table

Поиск
Список
Период
Сортировка
От Vincenzo Romano
Тема Re: not using indexes on large table
Дата
Msg-id 200704212258.07094.vincenzo.romano@gmail.com
обсуждение исходный текст
Ответ на not using indexes on large table  (Jeroen Kleijer <jeroen.kleijer@xs4all.nl>)
Список pgsql-performance
On Saturday 21 April 2007 22:17:42 Jeroen Kleijer wrote:
> I've tried several things but doing a query like:
> select distinct volume from project_access_times

I'm new too but an "order by volume"  could help!

In any case maybe a different table design with a separate table for the
"distinct volumes" could help even more.

--
Vincenzo Romano
----
Maybe Computers will never become as intelligent as
Humans. For sure they won't ever become so stupid.

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

Предыдущее
От: Jeroen Kleijer
Дата:
Сообщение: not using indexes on large table
Следующее
От: Andreas Kostyrka
Дата:
Сообщение: Re: not using indexes on large table