| Lists: | pgsql-bugs |
|---|
| From: | "Roman Galeev" <ip(at)ncom-ufa(dot)ru> |
|---|---|
| To: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | BUG #4874: vacuum doest work |
| Date: | 2009-06-23 14:42:46 |
| Message-ID: | 200906231442.n5NEgkXi004890@wwwmaster.postgresql.org |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
The following bug has been logged online:
Bug reference: 4874
Logged by: Roman Galeev
Email address: ip(at)ncom-ufa(dot)ru
PostgreSQL version: 8.1
Operating system: Debian Sarge
Description: vacuum doest work
Details:
I've constantly got messages like this:
2009-06-23 20:43:42 YEKST WARNING: database "testing" must be vacuumed
within 10532638 transactions
2009-06-23 20:43:42 YEKST ПОДСКАЗКА: To avoid a database shutdown,
execute a full-database VACUUM in "testing".
but issuing vacuum does not help.
I've issued vacuum, vacuum full, vacuum freeze several times.
The only change I see is decreasing number of transactions.
| From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
|---|---|
| To: | "Roman Galeev" <ip(at)ncom-ufa(dot)ru> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #4874: vacuum doest work |
| Date: | 2009-06-23 15:13:21 |
| Message-ID: | 15857.1245770001@sss.pgh.pa.us |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
"Roman Galeev" <ip(at)ncom-ufa(dot)ru> writes:
> I've constantly got messages like this:
> 2009-06-23 20:43:42 YEKST WARNING: database "testing" must be vacuumed
> within 10532638 transactions
> 2009-06-23 20:43:42 YEKST : To avoid a database shutdown,
> execute a full-database VACUUM in "testing".
> but issuing vacuum does not help.
You need to issue it as a superuser.
regards, tom lane
| From: | Роман Галеев <ip(at)ncom-ufa(dot)ru> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-bugs(at)postgresql(dot)org |
| Subject: | Re: BUG #4874: vacuum doest work |
| Date: | 2009-06-24 05:36:37 |
| Message-ID: | 20090624113637.7134eaae@lenobook.jh |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Lists: | pgsql-bugs |
На Tue, 23 Jun 2009 11:13:21 -0400
Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> записано:
> > 2009-06-23 20:43:42 YEKST WARNING: database "testing" must be vacuumed
> > within 10532638 transactions
> > 2009-06-23 20:43:42 YEKST ааааЁааааа: To avoid a database shutdown,
> > execute a full-database VACUUM in "testing".
>
> > but issuing vacuum does not help.
>
> You need to issue it as a superuser.
It helped, thank's a lot.
--
With best regards,
Roman Galeev