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
-------------------------------------------------------------------