Re: Problem with indexes

I think you have to do a vacuum analize.

For very small tables seq scan is faster then index scan.
After vacuum analize postgres will know the table size.

--- Przemyslaw Kowalczyk <przemyslaw.kowalczyk@engine.com.pl> wrote:
> Hi.
>
> I'm trying to manage apache access logs with Postgresql (7.1). I've
> parsed
> last month access logs for one of our sites into database. There are
> about
> 900 000 records. Then I've created index:
<SNIP>

=====
Chris Albertson
  Home:   310-376-1029  chrisalbertson90278@yahoo.com
  Cell:   310-990-7550
  Office: 310-336-5189  Christopher.J.Albertson@aero.org

__________________________________________________
Do You Yahoo!?
Check out Yahoo! Shopping and Yahoo! Auctions for all of
your unique holiday gifts! Buy at http://shopping.yahoo.com
or bid at http://auctions.yahoo.com