From: Albert REINER <areiner@tph.tuwien.ac.at>
To: PostgreSQL-SQL <pgsql-sql@postgreSQL.org>
Subject: Re: [SQL] Can VACUUM, but cannot do VACUUM ANALYZE
Date: Sun, 24 Oct 1999 17:18:46 +0200
Message-ID: <19991024171846.B27105@frithjof> (raw)
In-Reply-To: <Pine.LNX.4.20.9910231202050.9896-100000@fep132.fep.ru>
References: <19991023091819.C833@frithjof>
<Pine.LNX.4.20.9910231202050.9896-100000@fep132.fep.ru>
Thanks for your reply!
On Sat, Oct 23, 1999 at 12:04:38PM +0000, Oleg Broytmann wrote:
> On Sat, 23 Oct 1999, Albert REINER wrote:
> > I.e., I can VACUUM, but I cannot do VACUUM ANALYZE. Why should analyze
...
> 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?
From my original post:
> > albert@frithjof:/home/albert > psql
> > Welcome to the POSTGRESQL interactive sql monitor:
> > Please read the file COPYRIGHT for copyright terms of POSTGRESQL
> > [PostgreSQL 6.5.1 on i586-pc-linux-gnulibc1, compiled by gcc 2.7.2.1]
^^^^^ ^^^^^^^^^^^^^^^^^^^^^^ ^^^^^^^^^^^
I'm still using Linux kernel 2.0.35 (SuSE 5.3), but planning to
upgrade the kernel. I also built Postgres 6.5.1 with locale support.
>
> Oleg.
Thanks,
Albert.
--
--------------------------------------------------------------------------
Albert Reiner <areiner@tph.tuwien.ac.at>
Deutsch * English * Esperanto * Latine
--------------------------------------------------------------------------
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients from your mail client; the link fills in
the headers below: reply via email
Some clients, webmail especially, drop In-Reply-To and References from
a link, and the reply then starts a new thread: use the mbox below.
To: pgsql-sql@postgresql.org
Cc: areiner@tph.tuwien.ac.at
Subject: Re: [SQL] Can VACUUM, but cannot do VACUUM ANALYZE
In-Reply-To: <19991024171846.B27105@frithjof>
References: <19991023091819.C833@frithjof> <Pine.LNX.4.20.9910231202050.9896-100000@fep132.fep.ru> <19991024171846.B27105@frithjof>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox