BUG #3555: does not work VACUUM - Mailing list pgsql-bugs

From Dmitry
Subject BUG #3555: does not work VACUUM
Date
Msg-id 200708191644.l7JGi6XF087983@wwwmaster.postgresql.org
Whole thread Raw
Responses Re: BUG #3555: does not work VACUUM
Re: BUG #3555: does not work VACUUM
List pgsql-bugs
The following bug has been logged online:

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

root@darkstar:~# su postgres
postgres@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.

pgsql-bugs by date:

Previous
From: "Alejandro Sengès González"
Date:
Subject: POSTGRES - DATA RECOVERY
Next
From: Heikki Linnakangas
Date:
Subject: Re: BUG #3555: does not work VACUUM