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
