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

From: "Albert REINER" <areiner(at)tph(dot)tuwien(dot)ac(dot)at>
To: PostgreSQL-SQL <pgsql-sql(at)postgreSQL(dot)org>
Subject: Re: [SQL] Can VACUUM, but cannot do VACUUM ANALYZE
Date: 1999-10-24 15:18:46
Message-ID: 19991024171846.B27105@frithjof
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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(at)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(at)tph(dot)tuwien(dot)ac(dot)at>
Deutsch * English * Esperanto * Latine
--------------------------------------------------------------------------

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Albert REINER 1999-10-24 15:48:30 Re: [SQL] Can VACUUM, but cannot do VACUUM ANALYZE
Previous Message Sam O'Connor 1999-10-23 22:10:58 BUG in PgODBC found/fixed (win32)