Re: index usage - Mailing list pgsql-novice

From Tom Lane
Subject Re: index usage
Date
Msg-id 18165.1066850692@sss.pgh.pa.us
Whole thread Raw
In response to index usage  (Andrei Ivanov <andrei.ivanov@ines.ro>)
List pgsql-novice
Andrei Ivanov <andrei.ivanov@ines.ro> writes:
> The table contains ~140 rows and I've ran vacuum full analyze.

On a table that small, a seqscan is usually preferable because it takes
less I/O.  In your test case the index pages were evidently already in
RAM, so that no additional I/O was actually needed to consult the index
--- but in a production situation you'd not be able to count on that.

            regards, tom lane

pgsql-novice by date:

Previous
From: Josh Berkus
Date:
Subject: Re: Functional index problems. (Was: Many joins: monthly summaries S-L--O--W)
Next
From: Andrei Ivanov
Date:
Subject: advice