Re: More vacuum troubles

From: Dan Moschuk <dan(at)freebsd(dot)org>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: More vacuum troubles
Date: 2000-11-10 20:53:31
Message-ID: 20001110155331.A2902@spirit.jaded.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


| > vacuum some_table (without the analyze) completes quite happily.
|
| It sounds like you've got some corrupted data in that table. Plain
| vacuum doesn't really pay any attention to what's in the rows it's
| shuffling around, but vacuum analyze does...
|
| Does a SELECT * FROM that table succeed?

SELECT * FROM table does indeed succeed.

-Dan
--
Man is a rational animal who always loses his temper when he is called
upon to act in accordance with the dictates of reason.
-- Oscar Wilde

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Martin A. Marques 2000-11-10 21:08:12 Postgres article
Previous Message Tom Lane 2000-11-10 20:36:09 Re: More vacuum troubles