Re: efficient storing of urls

Поиск
Список
Период
Сортировка
От Martijn van Oosterhout
Тема Re: efficient storing of urls
Дата
Msg-id 20040301194942.GA17186@svana.org
обсуждение исходный текст
Ответ на Re: efficient storing of urls  (Shane Wegner <shane-keyword-pgsql.a1e0d9@cm.nu>)
Список pgsql-general
On Mon, Mar 01, 2004 at 11:23:45AM -0800, Shane Wegner wrote:
> Hmm, I don't think it's using the index.  I tried two indexes
> create index hit_date on hits(hit_date);
> create index hit_date2 on hits(hit_date,url_id);
> vacuum analyze;
>
> With the hope that it would use the multicolumn index for
> hit_date and url_id but it's still doing a seq scan on
> hits.

Try an index on (url_id,hit_date), there's a difference.
--
Martijn van Oosterhout   <kleptog@svana.org>   http://svana.org/kleptog/
> If the Catholic church can survive the printing press, science fiction
> will certainly weather the advent of bookwarez.
>    http://craphound.com/ebooksneitherenorbooks.txt - Cory Doctorow

Вложения

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

Предыдущее
От: Shane Wegner
Дата:
Сообщение: Re: efficient storing of urls
Следующее
От: Greg Stark
Дата:
Сообщение: Re: value too long error