BUG #3555: does not work VACUUM

From: "Dmitry" <dd442(at)mail(dot)ru>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #3555: does not work VACUUM
Date: 2007-08-19 16:44:06
Message-ID: 200708191644.l7JGi6XF087983@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 3555
Logged by: Dmitry
Email address: dd442(at)mail(dot)ru
PostgreSQL version: 8.1
Operating system: Linux Slackware 11
Description: does not work VACUUM
Details:

root(at)darkstar:~# su postgres
postgres(at)darkstar:/root$ postgres -D /var/lib/pgsql/data/ -P taxi
WARNING: database "baza" must be vacuumed within 976150 transactions
HINT: To avoid a database shutdown, execute a full-database VACUUM in
"baza".
WARNING: database "baza" must be vacuumed within 976150 transactions
HINT: To avoid a database shutdown, execute a full-database VACUUM in
"baza".

PostgreSQL stand-alone backend 8.1.5

backend>VACUUM;

WARNING: database "baza" must be vacuumed within 976005 transactions
HINT: To avoid a database shutdown, execute a full-database VACUUM in
"baza".
WARNING: database "baza" must be vacuumed within 976004 transactions
HINT: To avoid a database shutdown, execute a full-
[...]
WARNING: database "baza" must be vacuumed within 975895 transactions
HINT: To avoid a database shutdown, execute a full-database VACUUM in
"baza".
backend>

is not got use VACUUM, VACUUM FULL...

3 months PostgreSQL work together with 1C:Enterprice 8.1 server.

Prompt, how correct givenned mistake.

Thank you, Dmitry.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Heikki Linnakangas 2007-08-19 18:28:57 Re: BUG #3555: does not work VACUUM
Previous Message Euler Taveira de Oliveira 2007-08-19 01:18:19 reindexdb in Windows