>Hey people,
>have a very strange problem now...
>It's that when my database with the script i'm using a
>explain select * from acc where username='britta' yields an
>index scan. Very nice. But after some time being up the
>same thing yields a SEQUENTIAL scan. What's happening
>folks? =) No more than update's select's and vacuums has
>been invoked.
Are you doing vacuum or vacuum analyze? I believe only the 'vacuum analyze'
function cleans up the indexing statistics.
len