Re: [SQL] Can VACUUM, but cannot do VACUUM ANALYZE - Mailing list pgsql-sql

From Albert REINER
Subject Re: [SQL] Can VACUUM, but cannot do VACUUM ANALYZE
Date
Msg-id 19991024171846.B27105@frithjof
Whole thread Raw
In response to Re: [SQL] Can VACUUM, but cannot do VACUUM ANALYZE  (Oleg Broytmann <phd@phd.russ.ru>)
Responses Re: [SQL] Can VACUUM, but cannot do VACUUM ANALYZE
List pgsql-sql
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
--------------------------------------------------------------------------


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: [SQL] sum-function
Next
From: Tom Lane
Date:
Subject: Re: [SQL] Can VACUUM, but cannot do VACUUM ANALYZE