Dissapearing indexes, what's that all about? - Mailing list pgsql-general

From Daniel ?erud
Subject Dissapearing indexes, what's that all about?
Date
Msg-id 986140786.134zilch@home.se
Whole thread Raw
List pgsql-general
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.

Thanks! *hug*

Daniel Åkerud


pgsql-general by date:

Previous
From: Alexander Lohse
Date:
Subject: Using Indices
Next
From: "Len Morgan"
Date:
Subject: Re: Dissapearing indexes, what's that all about?