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(dot)kowalczyk(at)engine(dot)com(dot)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(at)yahoo(dot)com
Cell: 310-990-7550
Office: 310-336-5189 Christopher(dot)J(dot)Albertson(at)aero(dot)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