Re: [SQL] Can VACUUM, but cannot do VACUUM ANALYZE
От | Albert REINER |
---|---|
Тема | Re: [SQL] Can VACUUM, but cannot do VACUUM ANALYZE |
Дата | |
Msg-id | 19991024171846.B27105@frithjof обсуждение исходный текст |
Ответ на | Re: [SQL] Can VACUUM, but cannot do VACUUM ANALYZE (Oleg Broytmann <phd@phd.russ.ru>) |
Ответы |
Re: [SQL] Can VACUUM, but cannot do VACUUM ANALYZE
|
Список | 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 по дате отправления: