Re: efficient storing of urls

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(at)svana(dot)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