Received: from frithjof.reiner (qmailr@c102.dialin.tuwien.ac.at [192.35.243.112]) by hub.org (8.9.3/8.9.3) with SMTP id LAA52321 for ; Sun, 24 Oct 1999 11:45:00 -0400 (EDT) (envelope-from areiner@tph.tuwien.ac.at) Received: (qmail 27215 invoked by uid 500); 24 Oct 1999 15:18:46 -0000 From: "Albert REINER" Date: Sun, 24 Oct 1999 17:18:46 +0200 To: PostgreSQL-SQL Subject: Re: [SQL] Can VACUUM, but cannot do VACUUM ANALYZE Message-ID: <19991024171846.B27105@frithjof> Mail-Followup-To: PostgreSQL-SQL References: <19991023091819.C833@frithjof> Mime-Version: 1.0 Content-Type: text/plain; charset=us-ascii X-Mailer: Mutt 0.95.6i In-Reply-To: ; from Oleg Broytmann on Sat, Oct 23, 1999 at 12:04:38PM +0000 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 Deutsch * English * Esperanto * Latine --------------------------------------------------------------------------