Re: Problems Vacuum'ing
| От | Tom Lane |
|---|---|
| Тема | Re: Problems Vacuum'ing |
| Дата | |
| Msg-id | 9804.1080952520@sss.pgh.pa.us обсуждение исходный текст |
| Ответ на | Re: Problems Vacuum'ing (jseymour@LinxNet.com (Jim Seymour)) |
| Ответы |
Re: Problems Vacuum'ing
Re: Problems Vacuum'ing |
| Список | pgsql-hackers |
jseymour@LinxNet.com (Jim Seymour) writes:
> Again the difference: With WebObjects running, deleting rows and
> trying to vacuum immediately, even full, fails. Shut-down WebObjects
> and I can.
WebObjects is evidently holding an open transaction. Ergo, anything
deleted after the start of that transaction isn't vacuumable. You need
to do something about the client-side logic that is holding an open
transaction without doing anything ...
regards, tom lane
В списке pgsql-hackers по дате отправления: