Re: [GENERAL] verifying database integrity?

At 02:21 AM 6/9/99 +0800, Vadim Mikheev wrote:
>Valerie Mates wrote:
>> 
>> Hi -- Some clod turned off the power to my customer's computer -- a Linux
>> box with a Postgres server on it -- while it was running.  Ever since then,
>> certain PostgreSQL queries have been very slow.  We wonder how to tell if
>> the database was damaged.  Is there a program we can run to check the
>> integrity of the database?  (And is this the right list for me to ask this
>> question on?)
>
>Rebuild your indices.
>Run vacuum verbose.
>
>Vadim
>
>
Vacuuming did the trick.  I don't know how I managed not to find out that
we should have been vacuuming regularly.  I've set up a cron job to do it
nightly.  We had been tearing our hair out over this.  Many many thanks!!

-Valerie

    -------------------------------------------------------------------
      Valerie Mates  *  Web Developer  *  http://www.valeriemates.com
               valerie@cyberspace.org  *  (734) 995-6716 
    -------------------------------------------------------------------