Re: [SQL] Can VACUUM, but cannot do VACUUM ANALYZE

From: Oleg Broytmann <phd(at)phd(dot)russ(dot)ru>
To: Albert REINER <areiner(at)tph(dot)tuwien(dot)ac(dot)at>
Cc: PostgreSQL-SQL <pgsql-sql(at)postgresql(dot)org>
Subject: Re: [SQL] Can VACUUM, but cannot do VACUUM ANALYZE
Date: 1999-10-23 12:04:38
Message-ID: Pine.LNX.4.20.9910231202050.9896-100000@fep132.fep.ru
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

On Sat, 23 Oct 1999, Albert REINER wrote:
> I.e., I can VACUUM, but I cannot do VACUUM ANALYZE. Why should analyze
> do an ABORT? By the way, I do not notice any strange behavior with
> this database, and pg_dump works fine on it.

Once I saw similar behaviour. I found thta the problem was in broken
strcoll() function in glibc2; I compiled Postgres with locale support.
After upgrading (Debain GNU/Linux 2.0 to 2.1) I got newer libc, and the
problem gone away.
What system/config you are running? OS, compiler, postgres version,
compilation flags?

Oleg.
----
Oleg Broytmann http://members.xoom.com/phd2/ phd2(at)earthling(dot)net
Programmers don't die, they just GOSUB without RETURN.

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Florian Baumert 1999-10-23 12:07:09
Previous Message Albert REINER 1999-10-23 07:18:19 Can VACUUM, but cannot do VACUUM ANALYZE