Dissapearing indexes, what's that all about?

From: Daniel ?erud <zilch(at)home(dot)se>
To: pgsql-general(at)postgresql(dot)org
Subject: Dissapearing indexes, what's that all about?
Date: 2001-04-01 15:59:46
Message-ID: 986140786.134zilch@home.se
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Browse pgsql-general by date

  From Date Subject
Next Message Len Morgan 2001-04-01 16:13:36 Re: Dissapearing indexes, what's that all about?
Previous Message Alexander Lohse 2001-04-01 15:37:07 Using Indices